T
TBA
Excel 2002
Windows XP
I have two worksheets in a workbook, sheets 1 and 2 respectively. Each
sheet contains a rather large table that are for all intents and purposes
the same except that one table (sheet 2) has more up to date information
than the one in sheet 1.
Each sheet contains an X labeled column (column A in both) and a Y labeled
column (column B in both). The values in these columns are geographic
coordinates. What I'd like to do is add information from sheet 1 to sheet 2
based on matching coordinate pairs. For example, if on sheet 2 I have A2 =
1234.567 (X value) and B2 = 4567.890 (Y value), then I want to find the same
coordinate pair on sheet 1 and return the value in column E that corresponds
to that coordinate pair back to sheet 2 in a new column, say G2.
Any thoughts?
-gk-
Windows XP
I have two worksheets in a workbook, sheets 1 and 2 respectively. Each
sheet contains a rather large table that are for all intents and purposes
the same except that one table (sheet 2) has more up to date information
than the one in sheet 1.
Each sheet contains an X labeled column (column A in both) and a Y labeled
column (column B in both). The values in these columns are geographic
coordinates. What I'd like to do is add information from sheet 1 to sheet 2
based on matching coordinate pairs. For example, if on sheet 2 I have A2 =
1234.567 (X value) and B2 = 4567.890 (Y value), then I want to find the same
coordinate pair on sheet 1 and return the value in column E that corresponds
to that coordinate pair back to sheet 2 in a new column, say G2.
Any thoughts?
-gk-