VLOOKUP for cells with different values

G

gcukarski

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,
 
P

Pete_UK

You can use wildcards in VLOOKUP, like this:

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

Hope this helps.

Pete
 
G

gcukarski

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

smartgal

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.
 
Top