I am trying to use a Range VLOOKUP based upon the criteria of color in this example. I have another set of data but used this example for simplicity and business reasons. But I need to use the table range that corresponds with the color. I have a lot of values so hard coding is not an option. Basically I need to come up with the Tier level in table 1. I also want to be able to change the Min Max values and see how that balances the numbers for customers in each category. Any help would be great as I have a very large set of data I am working with.
<tbody>
</tbody>
<tbody>
</tbody>
Thank you very much for your time and effort!
Color | Invoice $ | Tier |
Blue | 3 | |
Blue | 17 | |
Black | 571 | |
Yellow | 81 | |
Black | 1026 | |
Blue | 1 | |
Yellow | 97 | |
Yellow | 175 | |
Black | 386 |
<tbody>
</tbody>
Color | Min | Max | Tier |
Black | 0 | 500 | Tier 3 |
Black | 500 | 1000 | Tier 2 |
Black | 1000 | Tier 1 | |
Yellow | 0 | 80 | Tier 3 |
Yellow | 80 | 160 | Tier 2 |
Yellow | 160 | Tier 1 | |
Blue | 0 | 50 | Tier 3 |
Blue | 50 | 100 | Tier 2 |
Blue | 100 | Tier 1 |
<tbody>
</tbody>
Thank you very much for your time and effort!