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

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

HTH,
Ryan---

--
RyGuy


"Hamed parhizkar" wrote:

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