Reference a sheet as a key to insert data.

[gibby3164]

I have attached two xls files.

"Area codes with zip codes" is the key that I need to use. Column A has a list of area codes. Column B has the zip code I would like to use for the corresponding area code. So, for example A1 is 201, and B1 is 07401.

In the sheet "area codes" is a list of only area codes in column A. I need to take that sheet and reference the first, to say if for example, A28=603 it will look at the sheet with zip codes, find 603 (in "area codes with zip codes", and insert 03601 in B28.

I would appreciate any assistance, and let me know if I need to clarify anything!

Thank you.

[arthurbr]

Hi and welcome to the board
Have a look at the VLOOKUP function. That should do the trick
( BTW your file "area codes with zip" seems empty)
Cheers