| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup Across Multiple Columns - Return Category names
I'm trying to figure out a formula for this scenerio:
col a col b col c col d col e col f col g name cat1 cat2 cat3 cat4 cat5 cat6 Smith, John x x x 1 x x Taylor, Mary 1 x 1 x x x Adams, Ted x 1 x x 1 x "X" meaning the cell is blank Is there a formula that will lookup Taylor,Mary & return all the category names ("cat1, cat2, cat3, etc) where there is a number "1" showing? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| V lookup with 2 criteria to return results for multiple columns | Excel Worksheet Functions | |||
| lookup for a value in multiple columns and return a result | Excel Discussion (Misc queries) | |||
| BIFF - Help!! lookup numbers in multiple columns and return one nu | Excel Worksheet Functions | |||
| how can i apply labels (or category names) to columns? | Excel Worksheet Functions | |||
| Lookup in Multiple Columns, Return Multiple Values | Excel Worksheet Functions | |||
Threaded Mode
