View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Atkisson Tom Atkisson is offline
external usenet poster
 
Posts: 8
Default 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