G
Guest
I have a table in columns A to F (but assume table size can vary). Column A
contains codes and columns B to F contain numeric data. This numeric data is
organised in ascending sequence (B to F) within each row.
I have a VBA (UDF) function which works fine but I am interested to know if
a possible solution exists using a formula.
What is required is to match a given code with codes in column A (to give
the ROW) and then to match a lookup value with the numeric data in columns B
to F for the ROW.
The first match (if indeed the MATCH function is used) will have a
"match_type=0" and the second match a "match_type=1" i.e. return a value less
than or equal to the "lookup_value".
My "problem" is that I can't figure out how to cater for the "dynamic" row
in the second Match.
Thanks in advance.
contains codes and columns B to F contain numeric data. This numeric data is
organised in ascending sequence (B to F) within each row.
I have a VBA (UDF) function which works fine but I am interested to know if
a possible solution exists using a formula.
What is required is to match a given code with codes in column A (to give
the ROW) and then to match a lookup value with the numeric data in columns B
to F for the ROW.
The first match (if indeed the MATCH function is used) will have a
"match_type=0" and the second match a "match_type=1" i.e. return a value less
than or equal to the "lookup_value".
My "problem" is that I can't figure out how to cater for the "dynamic" row
in the second Match.
Thanks in advance.