Sheet1 contains 2 columns: zip code and an entity name Sheet2 contains 3 columns: zip code, latitude, and longitude
Sheet1 has 348 rows and sheet2 has 33234 rows I am attempting to to match the entity with a relative lat/lon using it's associated zip code. I need sheet1 to contain zip code, entity name, latitude, and longitude. I was offered the formula "=VLOOKUP(A1;Sheet2.A1:B100;2;0)" as an example, but I have had no success with this so far. Thanks to all who can offer suggestions or solutions. Tim
