Joining two tables using a common column
Hi all,
I've searched but have not been able to find a problem similar to mine. So I apologize if somebody have already asked the same question.
I attached an excel file should you need more info.
I basically want to join the two tables in Sheet 1 and Sheet 2 using the email column from each sheet. If email is matched, then join the rows, otherwise leave blank or #N/A
Thank you very much.
Opened the sample, but there is no data in the columns, and no explanation of what is supposed to wind up where?
Which table gets populated, or does a third table have to be created?
Maybe throw some dummy data in the tables and a few expected results; so we can see what you need
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Is this what you want?
=IFERROR(INDEX(Sheet1!$A$2:$Q$28,MATCH($A2,Sheet1!$R$2:$R$28,0);MATCH(B$1,Sheet1!$A$1:$Q$1,0)),"")
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
Sorry for lacking of content dredwoft. My goal is to add/join table from Sheet 2 with the table from Sheet 1 (I will delete unmatched data). I modified the sample so I hope it makes more sense now.
@popipipo: From what I read, it seems to be what I want but it gave me error, I will see if I need to change your function a little bit to make it work.
Thanks all.
My solution is very similar to popipipo's actually...In S2:
Formula:
=IFERROR(INDEX(Sheet2!$B$2:$S$12,MATCH($R2,Sheet2!$A$2:$A$12,0),MATCH(S$1,Sheet2!$B$1:$S$1,0)),"")
drag down and across, see Attached
Hope this helps
Thank you very much. You two saved my life
You are welcome
Please remember to mark the thread as solved if you are satisfied with your solution :
To mark thread "Solved", go to the top of the thread,click "Thread Tools",click "Mark as Solved"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks