Table lookup problem

[Graham]

I have an array as shown below. The given values are the column headings ie
1,2 3, 4, or 5 and one of the values in the array. eg 2.1 in column 3 would
return the value of 200 in the left hand column.

1 2 3 4 5

0 1.9 1.7 1.5 1.3 1.1
50 2.1 1.9 1.6 1.4 1.2
100 2.3 2.1 1.8 1.5 1.3
150 2.5 2.2 1.9 1.7 1.5
200 2.7 2.4 2.1 1.8 1.6
250 2.9 2.6 2.2 1.9 1.7
300 3.1 2.8 2.4 2.1 1.8
350 3.3 2.9 2.5 2.2 1.9


I have tried various index and lookup options but no luck so far. I would be
grateful for any help.

Kind Regards
Graham Haughs
Turriff Scotland

 

[Frank Kabel]

Hi
try
=INDEX(A1:A20,MATCH(2.1,OFFSET($A$1:$A$20,0,MATCH(3,B1:F1,0))))

 

[Graham]

Many thanks for that Frank. It fits the bill perfectly.

Graham