| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
HLOOKUP() to return heading cells
Think its optional ..
From Excel's Help INDEX(array,row_num,column_num) If array contains only one row or column, the corresponding row_num or column_num argument is optional. In H2: =INDEX(A$1:F$1,,MATCH(G2,A2:F2,0)) would have worked just as well -- Max Singapore http://savefile.com/projects/236895 Downloads:20,000 Files:362 Subscribers:62 xdemechanik --- "FARAZ QURESHI" wrote in message ... Max! U r the best no doubt! However, can you explain how does this formula work? The part MATCH(G2,A2:F2,0) has been inserted in the Row_Num, instead of Col_Num? The formula as per the F1 help should have been =INDEX(A$1:F$1,1,MATCH(G2,A2:F2,0))? Don't you think so? |
| 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
