Merging worksheets in Excel.
March 3, 2009 1:15 PM Subscribe
Excel-Fu Filter: I need to merge latitude and longitude values (in two columns) corresponding to a specific site from one worksheet to the corresponding site in another worksheet.
posted by schyler523 to computers & internet (7 answers total) 2 users marked this as a favorite
For example, in the Lat/Long worksheet column A is the site (AK03), B is Latitude, C is the Longitude. The other worksheet has column A (Site) and B (pH). The problem with a simple copy/paste is that Worksheet 2 has multiple listings for each site.
There must be a simple formula that would accomplish this, but I have searched Excel Help and many forums and am no closer to a solution. Hope me.