VLOOKUP for cells with different values
 

My file is:

John Smith 2%
JohnSmih 2%
John Smit 2%

I need VLOOKUP that will search for cells that start with same 4 letters. I
this case, every cell that starts with John, I need it to return 2%.

Please help.

Thanks,

VLOOKUP for cells with different values
 

You can use wildcards in VLOOKUP, like this:

=VLOOKUP("John*",table,column,type)

Hope this helps.

Pete

On Apr 8, 2:24*pm, gcukarski
wrote:
My file is:

John Smith * * 2%
JohnSmih * * *2%
John Smit * * *2%

I need VLOOKUP that will search for cells that start with same 4 letters. I
this case, every cell that starts with John, I need it to return 2%.

Please help.

Thanks,

VLOOKUP for cells with different values
 

Thanks,
but I need to lookup by the cell, my file is huge, i need same VLOOKUP
formula for every cell.
Any other ideas?



"Pete_UK" wrote:

You can use wildcards in VLOOKUP, like this:

=VLOOKUP("John*",table,column,type)

Hope this helps.

Pete

On Apr 8, 2:24 pm, gcukarski
wrote:
My file is:

John Smith 2%
JohnSmih 2%
John Smit 2%

I need VLOOKUP that will search for cells that start with same 4 letters. I
this case, every cell that starts with John, I need it to return 2%.

Please help.

Thanks,

VLOOKUP for cells with different values
 

Depending on how many results you need to return (John, Josh, Mary, Kate,
etc.) I'd just make a table of those results. I would also add a column in
your original data and segregate just the first four characters (use the
"data / text to columns" feature and choose fixed width), then you'll have
standardized source and vlookup info for easy comparison.

"gcukarski" wrote:

Thanks,
but I need to lookup by the cell, my file is huge, i need same VLOOKUP
formula for every cell.
Any other ideas?



"Pete_UK" wrote:

You can use wildcards in VLOOKUP, like this:

=VLOOKUP("John*",table,column,type)

Hope this helps.

Pete

On Apr 8, 2:24 pm, gcukarski
wrote:
My file is:

John Smith 2%
JohnSmih 2%
John Smit 2%

I need VLOOKUP that will search for cells that start with same 4 letters. I
this case, every cell that starts with John, I need it to return 2%.

Please help.

Thanks,