VLOOKUP to move information from one spreadsheet to another

[calee1983]

Hello everybody,

So I'm looking for some help to transfer data from one spreadsheet to another. So spreadsheet "ZIPCODE HELP" has a bunch of zip codes in it and I would like to use VLOOKUP to populate information/data for that same zip code from spreadsheet "CONUS DATA HELP".

As always I thank you for your time!

[etaf]

you can use vlookup or index/match to pull the information across

what information did you wish to transfer - if all

i copied the sheet into the same workbook and used
=INDEX(Sheet1!B:B,MATCH('Sheet1 (2)'!A2,Sheet1!A:A,0))
to copy the data in column B across to the zipcode sheet
BUT there where only two matches anyway

is this just a sample ?

you can then change the index/match to lookup other columns by changing
=INDEX(Sheet1!B:B,MATCH('Sheet1 (2)'!$A2,Sheet1!A:A,0))
just the column reference