Match cell content with another file, and return the value from the next column over

[mistert]

Hi there.

I have two files. They both have US census tract numbers in a column GEOID2010. One also has a CSA2010 text description associated with each census tract.

I need to match the cell with a census tract in the first file (example1).xlsx with the census tracts in the second file (example2.xlsx), and then return the CSA2010 text from the next column over to the first file.

I've attached two example files.

Thanks for any help you might have!

[hemesh]

Try this =INDEX([example2.xlsx]Sheet1!$C$2:$C$21,MATCH(B2,[example2.xlsx]Sheet1!$B$2:$B$21,0))

change the references according to your requirement.
If this solves your query then click" * " in the bottom left corner of my post and mark thread as solved

[mistert]

Thanks for the reply. It works great in the example files I provided, but when I put it into the actual files it returns #NA. I have gone over and over the formula and have now idea where the error is. Any thoughts on a likely suspect?

[mistert]

Here's what the formula looks like transferred to the actual file:
=INDEX([CensustoCSA.xlsx]CensusCSA!$C$2:$C$201,MATCH(B2,[CensustoCSA.xlsx]CensusCSA!$B$2:$B$201,0))
and I'm just getting #NA

[mistert]

Figured it out: missing data! Thanks! Solved.