| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return column heading
Hi
I have a large list of pupils effort grades within the subjects that they are studying: the list of all the subjects (about 18) is in row 1, pupil names in column 1. If John Smith is studying music, and is awarded a 'A', how can I search the row for the 'A', and return the column heading (i.e. Music)? I've tried lookups and match and offset, but to no avail. I'm obviously missing something... Thanks Tubthumper |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| *HELP* Need a cell to return a column heading | Excel Discussion (Misc queries) | |||
| Return Column Heading after lookup | Excel Worksheet Functions | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
| I have an IF formula to return column heading for FALSE | Excel Discussion (Misc queries) | |||
| Formula to Return Column Heading | Excel Discussion (Misc queries) | |||
Threaded Mode
