| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
reference with variable row number ?
You're welcome, Max!
Biff "Max" wrote in message ... Thanks, Biff ! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Biff" wrote in message ... Well, there wasn't enough detail in the post so I basically took a WAG as to what they wanted and it goes like this: ......A.....B.....C.....D 1...X1...X2...X3...X4 2....5......8......7.....6 3....1......4......7.....2 4....0......6......1.....3 5....9......2......8.....4 6....8......4......1.....7 Return column header based on the (relative) user selected row that contains the lookup value. A10 = lookup value = 1 A11 = row number = 5 =INDEX(A1:D1,MATCH(A10,INDEX(A2:D6,A11,),0)) Returns: X3 Biff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Data off Web - Need Function Help | Excel Worksheet Functions | |||
| Hyperlink function fails when using variable row number | Excel Worksheet Functions | |||
| How do I extract a date as text not the 1900 reference number | Excel Discussion (Misc queries) | |||
| Absolute Worksheet reference number | Excel Discussion (Misc queries) | |||
| how to create a variable column in cell reference | Excel Worksheet Functions | |||
Threaded Mode
