currently i am using the below formula for in between range but i want add an additional column (type) for verifying how can it be done
=VLOOKUP(G2,B:D,3,TRUE)
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>
=VLOOKUP(G2,B:D,3,TRUE)
TYPE | FROM | TO | CLS | TYPE | DATA | CLS | |
AA | 0 | 79999 | D | AA | 56000 | D | |
AA | 80000 | 119999 | C | AA | 95000 | C | |
AA | 120000 | 169999 | B | AA | 130000 | B | |
AA | 170000 | 9999999 | A | AA | 250000 | A | |
AB | 0 | 100000 | D | AB | 50000 | ||
AB | 100001 | 300000 | C | AB | 200000 | ||
AB | 300001 | 500000 | B | AB | 450000 | ||
AB | 500001 | 9999999 | A | AB | 600000 | ||
AC | 0 | 500000 | D | AB | 715965 | ||
AC | 500001 | 750000 | C | AB | 243983 | ||
AC | 750001 | 950000 | B | AC | 250000 | ||
AC | 950001 | 9999999 | A | AC | 708492 | ||
AC | 1278067 | ||||||
AC | 850000 | ||||||
AC | 440773 | ||||||
AC | 566173 |
<colgroup><col width="64" span="8" style="width:48pt"> </colgroup><tbody>
</tbody>