|
Posted to microsoft.public.excel.misc
|
|
|
opposite of vlookup function?
HLOOKUP may work?
"ayl322" wrote:
i need a formula that is kind of opposite of vlookup.
in a table of data, i need to locate a specific data and return the
column heading of that data.
for example, let's say i have a table:
fruit veggies dairy
apple cucumber cheese
banana squash milk
if a1 = "apple"
i need to find a1 in the table and return "fruit"
is this possible?
any help would be appreciated!
--
ayl322
------------------------------------------------------------------------
ayl322's Profile: http://www.excelforum.com/member.php...fo&userid=9846
View this thread: http://www.excelforum.com/showthread...hreadid=570867
|