Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Any Way to Use Vlookup in Reverse? | Excel Discussion (Misc queries) | |||
Reverse VLOOKUP | Excel Discussion (Misc queries) | |||
REVERSE VLOOKUP | Excel Discussion (Misc queries) | |||
Reverse VlookUp | Excel Discussion (Misc queries) | |||
vlookup reverse// please help | Excel Worksheet Functions |