Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,688
Default 2 sources needed for vlookup

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 78
Default 2 sources needed for vlookup

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sports Comp Ladder tabulating help needed shaunl Excel Worksheet Functions 12 January 29th 14 02:25 PM
I NEED TO TAKE TWO SOURCES OF DATA AND SEE WHAT IS MISSING OUT OF. Gates Excel Discussion (Misc queries) 1 June 23rd 06 09:51 PM
Vlookup Alternative Needed Rita Palazzi Excel Discussion (Misc queries) 3 March 2nd 06 05:14 PM
Little more help needed for my IF formula Greg Excel Discussion (Misc queries) 4 March 1st 06 12:16 AM
"In Today's Dollars" help needed... Rick B Excel Worksheet Functions 4 January 12th 06 05:08 PM


All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"