Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Vlookups and wildcards?
I am trying to use a vlookup to lookup a value. Where the value I am looking up is say abcd but on my table it would be abc*. I can truncate abcd to abc and it will find it if I remove the *s from my table. However not every value on my table has an *. Is there a simple way to do this? I don't want to use true as I don't want an approximate match.
|
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependent vlookups - nested vlookups (maybe) | Excel Worksheet Functions | |||
Wildcards and if | Excel Worksheet Functions | |||
Wildcards | Excel Worksheet Functions | |||
Use wildcards | Excel Discussion (Misc queries) | |||
wildcards in vba | Excel Discussion (Misc queries) |