Forum Discussion
Solved
A complex lookup/index/match problem that I've encountered at work; how to pull data from both axes
Hello all, Any help is greatly appreciated as I have to present on this tomorrow. Not sure if I described this well enough in the title, but I need to pull a specific value from a reference table...
Ben_Cote I entered some "step-by-step" formulas in columns E, F and G and one that combines the three into one single formula. Makes is easier to follow. See if this does what you need.
Ben_Cote I entered some "step-by-step" formulas in columns E, F and G and one that combines the three into one single formula. Makes is easier to follow. See if this does what you need.
Hey Riny,
This is perfect! Exactly what I was looking for. Really appreciate it.
This is perfect! Exactly what I was looking for. Really appreciate it.