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,