Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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=$A 2)*(Sheet2!$B$2:$B$4=$B2),0)) Copy across a total of 5 cells Biff "Rookie_User" wrote in message ... 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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sports Comp Ladder tabulating help needed | Excel Worksheet Functions | |||
I NEED TO TAKE TWO SOURCES OF DATA AND SEE WHAT IS MISSING OUT OF. | Excel Discussion (Misc queries) | |||
Vlookup Alternative Needed | Excel Discussion (Misc queries) | |||
Little more help needed for my IF formula | Excel Discussion (Misc queries) | |||
"In Today's Dollars" help needed... | Excel Worksheet Functions |