Merging two columns from 2 Excel Sheets

aabbasi

Board Regular
Joined
Mar 4, 2002
Messages
188
Could anyone help me in MERGING data from two colums into one.

Eg:
From Person A, I got sheet with Column A having Cities name; Column B Zip Codes

From Person B, I got the same TYPE of information but data is different.

I want to creat one Sheet which LISTS ALL information about ALL cities in column A and ALL Zipcodes in column B.

Any help will be highly appreciated.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
_________________
If you can help a guy in trouble -
If you can sort that nagging problem -
Pease try, at home, at work or on a message board.

Others help you!
So PLEASE help if you can - If only the once.

Thank you -

Rdgs
======
This message was edited by Jack in the UK on 2002-05-01 13:53
 
Upvote 0
Sure thing,

If one list of names represents a subset of the other then you can likely apply a vlookup for each column of missing data.

Your Formulas will probably look like this:

=VLOOKUP(A2,Sheet2!A2:E200,2,false)

Where:
A2 = a name (or row identifier) that your trying to find in the other sheet

Sheet2!A2:E200 = the range your looking for the value in A2 (Column A on Sheet 2 should hold this value).

2 (the 3rd argument) is a column index. Basically this indicates that when you find the value from A2 in the Sheet2 range, the formula will output the 2nd column next to that value (column b in this example).

False = optional argument (you can also use 0). Indicates you want an exact match.

Hope that helps,
Adam
 
Upvote 0
Adam:

Thank you for explaining the formula.

It works if I am fetching data from Sheet2 only; how about if I want to capture information from Sheet 2 and Sheet 3 for Column A on sheet 1.

Any idea that can help me!!
 
Upvote 0
a little confused,

Are you writing this formula on a 3rd sheet or on one of the 2 existing ones?
From your last post, it sounds like you're trying to pull column A data that should exist on either Sheet1 or sheet 2 - and you want the formula to pull from the correct sheet.

To do this (and I admit I'm guessing what you want), you'd want to wrap an if statement around the formula. Something like:

=IF(COUNTIF(Sheet2!$A$2:$E$200,B2)>0,VLOOKUP(B2,Sheet2!$A$2:$E$200,2,false),VLOOKUP(B2,Sheet3!$A$2:$E$200,2,false))

Please msg back if I'm way out in left field.
Adam
 
Upvote 0
Hello Adam:

THANK YOU for helping me. It works for me...

Sorry for not being clear on my question..

Best Reagrds,
AAA
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,239
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top