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
|