| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| using wildcard for vlookup? | Excel Discussion (Misc queries) | |||
| wildcard in formula vlookup | Excel Discussion (Misc queries) | |||
| Wildcard vlookup perhaps? | Excel Discussion (Misc queries) | |||
| Vlookup with wildcard | Excel Discussion (Misc queries) | |||
| Wildcard search functions within Vlookup | Excel Worksheet Functions | |||
Threaded Mode
