Excel Lookup between two sheets

[remeng]

Hi All,

I am trying to get data for comparision from two different sheets and then calculate the difference based off of there X and Y coordinates. Here is the example: I want to lookup (0,2) value on both lists. Now I cannot combine the lists and list one has all the values and list two has a limited number of values. I want to lookup and then compair the values from list two to list one.

(Sheet 1)
X Y Diameter
1 0 0.5
1 2 0.45
0 2 0.2 *

(Sheet 2)
X Y Diameter
2 0 0.5
3 2 0.45
0 2 0.1 *


Output (sheet 3)

X Y Diameter 1 Diameter 2 Diference
0 2 0.2 0.1 (alreay have this)

Thank you in advance. Please note that the coordinates must match 100% for this to be correct.

Mike

 

[remeng]

PS: Here is the code that I have, I can not figure out how to Print the resulting Diameter:

=IF(AND(LOOKUP(A3,'Before Xhone'!$A$2:$A$5400,'Before Xhone'!$C$2:$C$5400),LOOKUP(Difference!B3,'Before Xhone'!$B$2:$B$5400,'Before Xhone'!$C$2:$C$5400)),,"bob")

 

[xlbo]

Have a look at VLOOKUP

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[remeng]

I resolved this issue with a combination of index match and lookup. If I have time later I will post the code.

Thanks,

All