View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teric506 Teric506 is offline
external usenet poster
 
Posts: 6
Default how do a create a lookup using first and last name

Hello,

I have two worksheets that I am trying to create a lookup for. They both
have id #'s columns that should be the same so I tried to do a vlookup only
to discover they are not the same. The only colomns on both sheets that are
the same are first and last name. I need them both becasue some many people
have the same last name but different first names and so forth. So what I am
trying to do is take joe shmo in sheet 1 and return the data for joe shmo
that resides in sheet 2. I cant for the life of me figure out how to do this.
Does anyone have any ideas?? Thanks so much.

Teri