VLOOKUP
Hello,
I am trying to match a name on one spreadsheet with a name on another
spreadsheet to receive a resulting contact.
For example on sheet one the following is shown:
A
Client Name
Sara Jones
On Sheet two the following information is shown:
A B
Name CPA Name
Jones, Sara Brown
The two sheets have a corresponding name, but they are not exact. Is there
a way to do a Vlookup for the name (even though they are not they same) and
receive the corresponding CPA name?
Thanks,
|