Key Word's for VLOOKUP

[Hamed parhizkar]

In one cell for instance I have the name "Steve H Martin". In another page I
have in the first column, names and in the second column, work positions. If
I write a Vlookup formula telling it to use "Steve H Martin" and go look on
the other page for the name and if found output the position that corresponds
to that name. I know how to do this but say in the name column his middle
intitial is not there. So under name column the name that appears is Steve
Martin, is there any way in the formula to have the formula identify matching
words and to pick it up even though it is not an exact match?

Thanks

 

[ryguy7272]

Ahhhh, fuzzy logic. Try this:
=vlookup("*"&"aaa",
=vlookup("&"*"aaa",

The * is a wildcard character.
Modify this example to suit your needs...

HTH,
Ryan---

 

[Hamed parhizkar]

Here is what I have:

IF(ISERROR(VLOOKUP(AZ11,'Employee List ALL STORES'!$A:$B,2,FALSE))

In AZ11 is SCOTT PETERSON

Under employee list all stores column A is SCOTT B. PETERSON.

How do I use the Wildcard?

 

[Dave Peterson]

Maybe...
=vlookup(substitute(AZ11," ","*"),'Employee List ALL STORES'!$A:$B,2,FALSE)