I have a long list with at least a dozen "PLN"s and hundreds if not thousands of combinations of RETAIL and BARGAIN prices. I'm trying to funnel them down into specific Labels. I have tried INDEX/MATCH and VLOOKUPs. I fear I may have to just write a massive IF statement unless I can find something that works consistently.
Essentially, I would like to first ID the PLN, then bump up against the RETAILS range, then against the BARGAIN range to find the final LABEL. On the left is a mini lookup table and what the labels should be. Then on the right is an example of the variations and what it *should* find for the LABEL column. I just don't know how to get to the Label column with a formula. Any help would be appreciated.
Essentially, I would like to first ID the PLN, then bump up against the RETAILS range, then against the BARGAIN range to find the final LABEL. On the left is a mini lookup table and what the labels should be. Then on the right is an example of the variations and what it *should* find for the LABEL column. I just don't know how to get to the Label column with a formula. Any help would be appreciated.