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

"Max" wrote in message
...
Biff,

For the benefit of all and the excel archives, why not include the core
text descripts of your suggestion? Your image link can be a complement to
that. Perhaps, like other silent readers of the newsgroups around the
world travelling in the same boat, I'm unfortunately not able to view the
link from where I'm accessing the newsgroups. If you were to include the
core text descripts, think that'll definitely be visible.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Biff" wrote in message
...
See if this screencap helps:

http://img320.imageshack.us/img320/6161/lookup1dx4.jpg

Biff