Vlookup with wildcard
 

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

Vlookup with wildcard
 

=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 wrote:

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

--

Dave Peterson

Vlookup with wildcard
 

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---

--
RyGuy


"Dave Peterson" wrote:

=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 wrote:

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

--

Dave Peterson