I have one column A with sites names and next 33 columns with site
categories
In each line i put an "x" mark at the proper column(category) that the
site belongs
I want to put a column in the column beside site's name and receive the
description of each category
The description of each category is the heading of each column ( row 1
)
vlookup or hlookup didn't work. I used match MATCH("x";B2:AH2;FALSE)
and i got the column where the x is located in numeric format
Can you suggest a solution to this ?
Thanks
--
bigexcelfan
------------------------------------------------------------------------
bigexcelfan's Profile:
http://www.excelforum.com/member.php...o&userid=30119
View this thread:
http://www.excelforum.com/showthread...hreadid=498080