Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

lookup if number falls within a range defined in the other table

Hello!


In the first table column A I have text strings, and in column B I have character count for that string ( =len(A1))


Texts length picture
Lorem ipsum dolores est ... 48
This is a fien day for ... 69


In the other table I have set columns with upper and lower bonds and resulting value they should return


low high result
0 58 cl1.png
59 101 cl2.png


I need formula to put in first table "picture" column the value of the second table column "result" if

number "length" falls withing "low" and "high" range.


Normaly I'd use LOOKUP, but here are two columns ... ?


Janis

Posted on Oct 31, 2012 12:47 PM

Reply
Question marked as Best reply

Posted on Oct 31, 2012 6:38 PM

Janis,


I'd suggest that you use MATCH in conjunction with INDEX or OFFSET or INDIRECT to retrieve the data in the row with the smallest number that exceeds the search value.


Jerry

1 reply

lookup if number falls within a range defined in the other table

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.