table lookup

  • Thread starter Thread starter engineer
  • Start date Start date
E

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,
 
Assuming your data in A1:D4

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

ctrl+shift+enter, not just enter
 
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,
 
Back
Top