Excel Two Way Lookup
This idea came up during and advanced Microsoft Excel course today and I wanted to share it once I came to a solution.
Using a combination of data validation menus, named ranges and an INDEX-MATCH function, I was able to create a two-way lookup.
Function Explanation Here:
TheTable= A3:D12
Coffee= G3
CoffeeList= A3:A12
Size= G6
SizeList= A3:D3
=INDEX(TheTable,MATCH(Coffee,CoffeeList,0),MATCH(Size,SizeList,0))
=INDEX(A3:D12,MATCH(G3,A3:A12,0),MATCH(G6,A3:D3,0))
File Download Here:
https://www.dropbox.com/scl/fi/ivon02...
Dawn Monroe Training
Microsoft Office Specialist Master
Wichita, KS, USA
https://dawnmonroetraining.com/
PLEASE SUBSCRIBE for more tips!
🔔 Subscribe for Updates 🔔
YouTube: / dawnmonroetraining
❤️ Connect on Social ❤️
LinkedIn: / dawnmonroetraining
Facebook: / dawnmonroe.training
💥 View Learning Opportunities💥
Calendar: https://learn.dawnmonroetraining.com/...
Website: https://dawnmonroetraining.com/
#microsoft #365 #excel #lookup #vlookup #indexmatch #twovariables