2 sources needed for vlookup

[Guest]

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?

 

[Biff]

Hi!

Try this:

Entered as an array using the key combination of CTRL,SHIFT,ENTER:

=INDEX(Sheet2!C$2:C$4,MATCH(1,(Sheet2!$A$2:$A$4=$A2)*(Sheet2!$B$2:$B$4=$B2),0))

Copy across a total of 5 cells

Biff

 

[Guest]

That worked perfect and I would like to incorporate the function (ISNA), this
way if #N/A is returned it will return a blank. I have not had any luck
however, do you have idea's?

J