Forum Discussion

AmberRose's avatar
AmberRose
Copper Contributor
Apr 20, 2020

Vlookup with Two variables

I am trying to figure out a way to lookup a value when two different variables match and can't figure out how to do it.  For the attached example I want to pull back the explanation on the December t...
excel
Formulas and Functions
cuboslav's avatar
cuboslav
Copper Contributor
Apr 20, 2020

AmberRose you can use array formula for that. Best if you convert your data into table. Please see attached file. It's not VLOOKUP but maybe it does the job for you.

{=INDEX(results_range;MATCH(criterion1&criterion2;criterion1_lookup_range&criterion2_lookup_range;0))}

Resources