B
Bob
I need a function to find 2 closest values in the same row of an array.
The Array is in Columns BD and BE. I need to find the closest value to
those values in cells BB and BC. The BB value can be looked up in
Column BD, and the BC value in column BE.
The result after finding the closest values in the same row to those
values specified in $BB7 and $BE7
will be the coresponding values in the same row in column BK and BL
What I have only works on one column at a time and numbers in columns
BB and BC are related to each other and must be the closest values to
thse reference values in $BB7 and $BE7
Here's my formula so far:
=INDEX(BK201:BK291,MATCH(MIN(ABS($BD200:$BD291-$BB$7)+ABS($BE200:$BE291-$BC$7)),ABS($BD200:$BD291-$BB$7)+ABS($BE200:$BE291-$BC$7),0))
How can I look up both look up values and return one row results from
BK and BL?
Thanks in advance for the help!
Bob
The Array is in Columns BD and BE. I need to find the closest value to
those values in cells BB and BC. The BB value can be looked up in
Column BD, and the BC value in column BE.
The result after finding the closest values in the same row to those
values specified in $BB7 and $BE7
will be the coresponding values in the same row in column BK and BL
What I have only works on one column at a time and numbers in columns
BB and BC are related to each other and must be the closest values to
thse reference values in $BB7 and $BE7
Here's my formula so far:
=INDEX(BK201:BK291,MATCH(MIN(ABS($BD200:$BD291-$BB$7)+ABS($BE200:$BE291-$BC$7)),ABS($BD200:$BD291-$BB$7)+ABS($BE200:$BE291-$BC$7),0))
How can I look up both look up values and return one row results from
BK and BL?
Thanks in advance for the help!
Bob