Joined: 23 Apr 2009
|Posted: Thu Apr 23, 2009 6:23 pm Post subject: wild cards in Vlookup
|I cannot get wild cards to work in Vlookup.
Vlookup(A3;A4:E1000,2,0) where A3 needs to be able to use wildcards.
For example A3 could contain:
A4:E1000 could contain
I want Vlookup to find Frankfurt* in other words find it whether it is any of the three formats. The lookup list will only contain one of the three forms (it could be any of them) but I want the first instance with frankfurt returned.
I've tried Vlookup(A3*;A4:A1000,2,0) to no avail.
What is the format for wildcards where the wild characters are AFTER the initial search text?