Karl, my sincere apologies,

As Harlan stated correctly in his posting, I had mis-read your original
posting and suggested the wrong formula.

The correct 1st formula for your original posting should have been:
=INDEX($A$1:$A$4,MATCH(G1,OFFSET($A$1:$A$4,,MATCH( F1,$A$1:$D$1,0)-1,),0))

where inputs
in G1: 6 (internal value within B2:D4)
in F1: 2 (value in 1st row vertically above the internal value in G1)

And the corrected adaptation for your "actual situation"
should read something like this:
=INDEX($A$100:$A$400,MATCH(G1,OFFSET($A$100:$A$400 ,,MATCH(F1,$A$100:$X$100,0)-1,),0))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---