Forum Discussion
Excel 2010 Reverse VLookUp
Peeps, I am trying to accomplish a reverse vlookup using Excel 2010. Here is what it looks like. I have a table with 5 columns and 25 rows. The 2nd through 5 columns are the raw data that I...
You can paste following formula in I3 and copy it down.
=INDEX($A$3:$A$11,MIN(IFERROR(MATCH(H3,INDIRECT(SWITCH(G3,60,"B3:B11",75,"C3:C11",90,"D3:D11",110,"E3:E11"))+1,1)+1,1),ROWS(A3:A11)))
hope it works for you !!