table lookup

[engineer]

My head hurts from trying to figure out how to do this. I want to specify a
row title in which to find the closest number specified. For example, if my
row titles are W,X,Y,Z....maybe I would specify 5.5 in row X. The value
returned should be 6.

W 3 5 7
X 2 4.5 6
Y 1 1.5 3
Z 0 1 2.5

Thanks,

 

[Teethless mama]

Assuming your data in A14

=MIN(IF((A1:A4="x")*(B14>=5.5),B14))

ctrl+shift+enter, not just enter

 

[engineer]

THANKS!!!

I was trying to use more complicated lookup functions. This is much simpler.

 

[engineer]

Teethless mama,
I just realized your formula isn't quit doing what I want. If I enter value
of 5, it should return 4.5, but it is still returning 6. I want it to return
whichever value it is closest to.

Thanks,