| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
column data retrieved based on value in header row
ba1 ba2 ba3 bb1 bb2 bb3 bc1 bc2 bc3
1 1 i want to return ba2 and bb2 1 1 1 (1) i want to return ba1, ba3, bb3, -bc2 1 i want to return bb1 i want to keep row one information "ba2 and bb2" in row one. Actually row 2 information since row one has the header row. So the ba2 in this senario would report in j2 and bb2 would report in k2. Sometimes the codes are for removal and report as a negative can i turn these red? i know i could make it work with vlookup but i have 60 columns and usually only 3 or 4 codes are used so i would like to have them together. Any help would be greatly appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pick from table based on row and column header | Excel Worksheet Functions | |||
| Copy data from other worksheet based on column header | Excel Discussion (Misc queries) | |||
| Display data retrieved from website and have it update periodicall | Excel Worksheet Functions | |||
| Graphing data retrieved weekly from essbase cube | Excel Discussion (Misc queries) | |||
| Multiple Queries, Qry 2 based on Data Retrieved from Qry 1 | Excel Discussion (Misc queries) | |||
Threaded Mode
