Dear all,
I'm looking for a smart formula to test if a number is between a range of 2 other number and then I need a susequent VLOOKUP to report on the other spreadsheet the value I need.
Just to explain in a better way with an example:
<tbody>
</tbody>
Now, I have another table where I have:
<tbody>
</tbody>
I need to include the Vlookup column the Text related to the range in the first table.
Thanks in advance, best regards, Carlo
I'm looking for a smart formula to test if a number is between a range of 2 other number and then I need a susequent VLOOKUP to report on the other spreadsheet the value I need.
Just to explain in a better way with an example:
Value Start | Value End | Text |
1 | 5 | Good |
6 | 10 | Poor |
11 | 15 | Awesome |
<tbody>
</tbody>
Now, I have another table where I have:
Value | VLookup |
2 | |
7 | |
13 |
<tbody>
</tbody>
I need to include the Vlookup column the Text related to the range in the first table.
Thanks in advance, best regards, Carlo