Excel create new filed question

[achintha]

Hi,

I have 2 work sheets in the same file

sheet one contains following info

name, address, city, state, phone

sheet 2 contains following information I downloaded form Australia Post webstite

City, PostCode

I want to add a extra column to sheet 1 that contains the post code for that city. I want to get the postcode from sheet 2 using the city.

How can I do this?

Thanks so much for all your help

 

[shemayisroel]

Hi & Welcome,

Seems like a VLOOKUP solution

see below for how to apply it to your sheet

http://www.contextures.com/xlFunctions02.html

 

[achintha]

Thank you so much

 

[shemayisroel]

Thank you so much

No probs, your welcome.