Hello,

I suggest to introduce a character which does not appear, or you could
get a wrong hit if a1=RedB and b1=lue:

=VLOOKUP(A1&"|"&B1,{"Red|Blue",10;"Green|Orange",2 0;"Purple|Yellow",
30},2,)

Regards,
Bernd