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...
As variant for data like this
in K3 it could be
=LOOKUP(1,0/FREQUENCY(I3,INDEX($C$3:$F$11,0,MATCH($H3,$C$2:$F$2,0))),$B$3:$B$11)and drag it down