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,