Forum Discussion
Formula Help IF/AND/XLOOKUP
I have tried an IF formula, and IF/AND formula, and XLOOKUP and nothing is returning the answer I need. I even tried a long way with the XLOOKUP formula. So can someone help me please. I have attache...
Even simpler:
=INDEX($B$1:$F$1,,MATCH(E12,$B$2:$F$2,1))
You don't need rows 3 and 4 at all. Especially since rows 2 and 3 are substantially identical.
Let me recommend that you become familiar with a more complete set of functions for looking up and referencing.