I am using the following formula, my problem is that the data that is being
used to look up is as follows: Doe, John and here is where the problem comes
in, what it is looking up is Doe, John T the data that is being looked up has
the persons middle initial and there is nothing I can do to change this.
=VLOOKUP(B13,everyone!$B$2:$E$560,4,FALSE)

Is there a way to use a wildcard with VLOOKUP or is there another way to do
this?
Thanks in advance for your help.

Fishdaddy