View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Rookie_User Rookie_User is offline
external usenet poster
 
Posts: 78
Default 2 sources needed for vlookup

OK, I don't know that vlookup is the right tool. I am trying to move data
from one worksheet to another.

Worksheet1 "Source"
Cola ColB ColC/D/E/F/G
Phone Name
_____________________
1111111111 Jay Smith xxxxx
2222222222 Tim Jones xxxxx

I need to find the occurence of the match on worksheet2 "Destination" where
the phone and name are found. When they are found then I need to transfer
columns C-G over to to the destination worksheet. Keep in mind the
destination worksheet already has the names and phone I just need to match
the two and transfer data --- any ideas?