Mar 19 2024 02:16 PM
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.
Mar 19 2024 02:55 PM
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.