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