Find a word containing in a lookup using VLOOKUP

You can do a sort of fuzzy match with VLOOKUP. If you aren‘t sure if your lookup table will contain Red, Red Masala, or Red Masala Pvt, you can use =VLOOKUP("Red*",Table,2,False), and Excel will find the first item in the lookup table that starts with Red.