VLOOKUP and wildcard

Fish · 02-14-2005, 12:06 AM

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

**duane** · 02-14-2005, 12:35 AM

hi, not sure if the database has the intial, or the criteria:

If it is the database, change the false to true in the vlookup.

If it is the criteria, use something like left(a1,len(a1)-2) if the criteria was in cell a1
to remove the last space and middle initial of the name

=vlookup(left(a1,len(a1)-2),range,2,false)

R.VENKATARAMAN · 02-14-2005, 03:06 AM

see this url

http://www.bettersolutions.com/excel...12107/12101924
1833391122202412121865.htm

I got solution to this

=VLOOKUP("a*",rv,2,FALSE)

mine excel 2000

but I suspect wildcard characters can be appended only to text
==================

Fish <[email protected]> wrote in message
news:[email protected]...
> 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

Tom Ogilvy · 02-14-2005, 09:06 AM

=VLOOKUP(left(B13,len(B13)-2),everyone!$B$2:$E$560,4,FALSE)

--
Regards,
Tom Ogilvy

"Fish" <[email protected]> wrote in message
news:[email protected]...
> 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