Reverse VLookup?
I have a WS that a info like the following:
Column A has Name of item.
Column B-E has numeric values pertaining to the item
Column F has formula that uses numeric values in B-E and give a total
At the bottom of Column F (say F20) is the Max of column F
My question is can you, with a formula or vlookup, in A20 put the name of
the item. I think I can figure out how to do this in VBA but was wondering
if there is a way to do it without it.
Thanks in advance
|