Works Great! Thanks!!
On 7/31/07, Anthony Chilco <[EMAIL PROTECTED]> wrote: > > 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] > >
