FoodYarnNerd
New Member
- Joined
- Jul 22, 2021
- Messages
- 8
- Office Version
- 365
- Platform
- Windows
I am trying to pull in data from one table into another and cannot figure out how to make it work.
I need to look up both the Material and the Size in a different table and then pull in the value into column V (first snip). However, the table that I need to pull from has the size information running across as column headers so a VLOOKUP will not work (second snip). I was hoping XLOOKUP or INDEX-MATCH would give me what I need but I cannot seem to get any formula to work here. Am I missing something obvious?
Thanks so much for any assistance!
I need to look up both the Material and the Size in a different table and then pull in the value into column V (first snip). However, the table that I need to pull from has the size information running across as column headers so a VLOOKUP will not work (second snip). I was hoping XLOOKUP or INDEX-MATCH would give me what I need but I cannot seem to get any formula to work here. Am I missing something obvious?
Thanks so much for any assistance!