table lookup
 

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,

table lookup
 

Assuming your data in A1:D4

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

ctrl+shift+enter, not just enter


"engineer" wrote:

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,

table lookup
 

THANKS!!!

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

"Teethless mama" wrote:

Assuming your data in A1:D4

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

ctrl+shift+enter, not just enter


"engineer" wrote:

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,

table lookup
 

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,

"Teethless mama" wrote:

Assuming your data in A1:D4

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

ctrl+shift+enter, not just enter


"engineer" wrote:

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,