What I am attempting to do is match a zipcode from one sheet to a zipcode in a different sheet and pull the associated lat/lon values from one to the other so I can match other data in the first sheet to the lat/lon data that is in the second sheet.
That probably sounds as bad as it reads, but I am matching the value on the first sheet to the same value on the second sheet and pulling data from the second sheet back to the first sheet so it can be used there. On 7/25/07, Anthony Chilco <[EMAIL PROTECTED]> wrote: > > Hi Tim, > What you want to do is probably quite simple and would most likely use > the Lookup, hlookup or vlookup function. It's difficult to provide more > help because I'm not sure what it is that you want to do. What do you > mean by 'associated to a particular field in each sheet.' and 'using a > field in one sheet'? By 'field', do you mean the contents of a certain > cell, or perhaps a label above a column of data or beside a row of data. > Pasting a small section of the data in you reply as an example would help. > tc > > Tim Billingsley wrote: > > To begin, I have two spreadsheets and I need data from one sheet added > to > > another sheet, but I need them associated to a particular field in each > > sheet. > > > > Is there a way to search one sheet using a field in one sheet to locate > the > > associated data in the other sheet and bring back the results back to > the > > original sheet? > > > > > > Thanks for any direction or guidance you may have to offer. > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > >
