help pulling data

[ark1]

I need some help with an issued I am having.

I am trying to pull data from one sheet into another sheet.

sheet 1 I have 3 columns city | state | zip
sheet 2 I have 3 columns city | zip | area

I am trying to add a 4th column to sheet 1 where it is to show the area from sheet 2 based on the comparison of zips between zip 1 and 2.

Sheet 1: Column A: Zip, Column B: City, Column C:State
Sheet 2: Column A: City, Column B: Zip, Column C: Area

Thank you in advance.

[NBVC]

Try Vlookup()

e.g

=Vlookup(A2,Sheet2!B:C,2,0)

Where A2 contains first ZIP to lookup in Sheet2

Copy formula down.

[ark1]

I am not having any luck. With this formula. Is there any other way?

[NBVC]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[ark1]

I have attached the file. Let me know if you need more explanation. I thank you in advance for all your help.

***Updated with new worksheet with what I am looking to achieve.

[ChemistB]

In Sheet1 D2, copied down

Please Login or Register  to view this content.

However, your zip codes on sheet1 are formatted as text, on sheet2 as numbers. Therefore you won't get any matches.

One way to fix that, select column A of Sheet1. Go to "Text to Columns", click on "Finish" That should convert them to numbers.

Does that work for you?

[NBVC]

See attached.

The problem was that your codes in Sheet1 are text strings, while in Sheet2 they are numeric... I changed Sheet1 by selecting column A and going to Data|Text to Columns and clicking Finish... this converted column A to General (numbers).

Then the formula worked.

Seeing as there are some that aren't found at all in Sheet2, I add an error handler to return a blank if the zip code doesn't exist in sheet 2.

so new formula is: =IF(ISNA(VLOOKUP(A2,Sheet2!B:C,2,0)),"",VLOOKUP(A2,Sheet2!B:C,2,0))

[ark1]

Worked perfectly. You guys are the best. Thank you so much for everything.

[NBVC]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save