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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HLOOKUP() to return heading cells
In H2: =INDEX(A$1:F$1,MATCH(G2,A2:F2,0))
Copy down to H13 -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- "FARAZ QURESHI" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HLOOKUP() to return heading cells
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? Need your expert guidance in this regard! Thanx again! -- Best Regards, FARAZ A. QURESHI "Max" wrote: In H2: =INDEX(A$1:F$1,MATCH(G2,A2:F2,0)) Copy down to H13 -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- "FARAZ QURESHI" wrote: 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 |
#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? |
Reply |
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) |