| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HLOOKUP() to return heading cells
Cells A1:F1 consists of headings:
Class-I; Class-II; Class-III; Class-IV; Class-V; Class-VI; Cells A2:F13 consists unit price of every Class during each of the 12 months. I want to insert a formula in H2:H13 which shall consider the corresponding Value in G2:G13, lookup in the respective cells of the same row in columns A:F and return the EXACT relevant Class Heading from A1:F1. -- Best Regards, FARAZ A. QURESHI |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lookup Value and Return Column Heading | Excel Worksheet Functions | |||
| Return the value of a column heading | Excel Discussion (Misc queries) | |||
| Return column heading | Excel Worksheet Functions | |||
| return a collum heading | Excel Worksheet Functions | |||
| LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
Threaded Mode
