Match two columns of data and bring over two other columns

Copper Contributor

I am trying to match two columns of data. One column has zip codes, and the other has the zip code and the LAT AND LNG. So I want to match what is in Column A to Column E, and make the LAT and LONG come with it. I have tried all combos of VLOOKUP, INDEX, and MATCH that I have found and just cant make it work.


Screenshot 2024-03-19 165636.png


1 Reply


Select A2.

What do you see in the formula bar? 01521 or 1521? I expect the former.

Select E2.

What do you see in the formula bar? 00601 or 601? I suspect the latter.