Merging two columns from 2 Excel Sheets

[aabbasi]

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.

[Asala42]

G'day,

You're likely looking at a VLOOKUP approach.

Adam

[aabbasi]

Thank you for your reply..

Can you help me how to use VLookup..I never used it!

[Jack in the UK]

_________________
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 ]

[Asala42]

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

[aabbasi]

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!!

[Asala42]

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

[aabbasi]

Hello Adam:

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

Sorry for not being clear on my question..

Best Reagrds,
AAA