Thread: VLOOKUP
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sara sara is offline
external usenet poster
 
Posts: 82
Default 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,