Best match lookup.

[Brian Tam]

I’m trying to lookup UPC’s and have it tell me what is the best size (based on my criteria)

What I’m doing right now is entering the UPC.
Vlookup the Style #
Vlookup the Color
Vlookup the Size


Right now I’m stuck on how to get multiple results by matching both Style# and Color and giving me the available sizes.
After that I would like it to tell me if there is a better size (if so give me the size). If the one entered is the best size then say “True”

I gave the SIZES a value (I thought that might make it easier).

I’ve included an example of what I’m trying to accomplish and my weak attempt.

Thank for you help!
Brian