| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Numeric reference of column. Data Grab ?
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match Each Numeric occurrence and Return Individual Rows of Data | Excel Worksheet Functions | |||
| Help with Grouping the numeric data stored in one column. | Excel Worksheet Functions | |||
| match and count words | Excel Worksheet Functions | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
