| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to determine column heading from lookup
Say I have a table for phone commission
--------------------------- Handset - TariffA - TariffB --------------------------- Nokia1 - £50 - £100 Nokia2 - £60 - £200 Sony1 - £60 - £300 --------------------------- and on another sheet I have --------------------------- Handset - Expected - Actual --------------------------- Sony1 - £300 - x --------------------------- I know I have a Sony1, and that I have £300 - how do I return "TariffB" as the cell value, X? Any ideas on how to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup using row & column heading. | Excel Discussion (Misc queries) | |||
| Lookup value,return column heading | Excel Worksheet Functions | |||
| Lookup Value and Return Column Heading | Excel Worksheet Functions | |||
| Return Column Heading after lookup | Excel Worksheet Functions | |||
| Lookup min & column heading | Excel Worksheet Functions | |||
Threaded Mode
