Vlookup with wildcard

[ryguy7272]

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:B5)))

Do anyone have any different ideas?

Regards,
Ryan--

 

[Dave Peterson]

=vlookup("*"&"aaa", ....

will look for the first entry that ends with AAA.

But if you know you're looking for "total aaa", why not just look for
"total AAA"???

An alternative, create a pivottable (instead of using data|subtotals) and then
use =vlookup() to search that table.

 

[ryguy7272]

I was looking for AAA and trying to compare it to Total AAA. I like the idea
of a Pivot Table. I use PTs all the time. I honestly didn't think about it
for this project. I will experiement with it next time I have access to the
project. Thanks for the idea!!

Regards,
Ryan---