| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Array Formula to return Header
Trying to return the header of the cell in the range E2:P2 that has a value greater than 499 and less than 1500.
Formulas, as is, returns header from P column while value of 550 is in L2. =INDEX($E$1:$P$1,MAX(E2:P2499,E2:P2<1500,COLUMN(E 2:P2)-COLUMN($E$1))+1) Thanks Howard |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Column Header from an Index/array, finding Large with a userinput date | Excel Worksheet Functions | |||
| Return column header within an array when a value is met | Excel Worksheet Functions | |||
| Lookup Value in Range/Array and Return Column Header Value | Excel Discussion (Misc queries) | |||
| Lookup Value in Range/Array and Return Column Header Value | Excel Worksheet Functions | |||
| Lookup Value in Range/Array and Return Column Header Value | Excel Programming | |||
Threaded Mode
