Hi Tim, If sheets 1 and 2 have the zip codes in column A and sheet 2 has latitude in C and longitude in D, then
this should return the latitude: "=VLOOKUP(A1;Sheet2.$A$1:$D$40000;3;0)" and this should return the longitude: "=VLOOKUP(A1;Sheet2.$A$1:$B$40000;4;0)" If you put these two formulae in cells C1 and D1 of sheet A, then fill down to row 348, you should get what you want. tc Tim Billingsley wrote:
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
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
