Compare excel data [Closed]

Report
-
venkat1926
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

In excel i have say the following coordinate data:
2792691.388 215476.765 423.165
2792691.388 215526.765 423.045
2792691.388 215576.765 422.925
2792691.388 215626.765 422.791
2792691.388 215676.765 422.645
2792691.388 215726.765 422.511
2792691.388 215776.765 422.383
2792691.388 215826.765 422.255
2792691.388 215876.765 422.130
2792691.388 215926.765 422.005
2792691.388 215976.765 421.880
2792691.388 216026.765 421.755
2792691.388 216076.765 421.629
2792691.388 216126.765 421.505



and another set of data is as follows:
2792691.388 215476.765 -0.170
2792734.388 215476.765 -0.100
2792777.388 215476.765 -0.289
2792820.388 215476.765 -0.300
2792863.388 215476.765 0.166
2792906.388 215476.765 0.476
2792949.388 215476.765 0.263
2792992.388 215476.765 0.516
2793035.388 215476.765 0.010
2793078.388 215476.765 0.499
2793121.388 215476.765 0.217
2793164.388 215476.765 0.108
2793207.388 215476.765 0.003
2792691.388 215526.765 -0.050


Whats the right formula that can compare the first two columns from the first table and match it with the second table and give me the third column from the second table.


for an example:
The second row in the first table matches the last row in the second table,, result should look like this:
2792691.388 215526.765 423.045 -0.050


1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
790
download the file from

http://speedy.sh/nENFy/zaidshb-141229.xlsx

firsts set in A to C second set F to H
see the formula in D1
invoke this formula with
CONTROL SHIFT ENTER
copy D1 to D2, D3 etc down till data is there