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