I am wondering if there is a way to use some kind of fuzzy logic with a
vlookup, or some kind of vlookup alternative? Can I look for AAA as a lookup
criteria, and in my table array search for Total AAA?

Can I use something like this?
=SUMPRODUCT(ISNUMBER(SEARCH("*BAIR",A1:A5))*((B1:B 5)))

Do anyone have any different ideas?

Regards,
Ryan--


--
RyGuy