Lookup Type Question

[Guest]

I have 2 tables:


A B C D E F
Table1 Table2
Number ID Number ID
12 598296 15 598296 3
12 598296 15 598296 3
13 598327 17 598327 4
13 598327 17 598327 4
13 598327 17 598327 4
13 598327 17 598327 4
13 598327 17 598327 4
13 598327 17 598327 4
13 598327 12 598589 0
13 598327 12 598589 0
13 598327
13 598327
12 598589
12 598589
12 598589


Is there a formula that I can use in table 2 / F4, that will look at the
value in E4 and look for a match in table 1 / B4:B12. If there is a match,
subtract Col d from Col a ?

Thank you in advance.

 

[Jason Morin]

=D4-IF(COUNTIF(B:B,E4),INDEX(A:A,MATCH(E4,B:B,0)),0)

HTH
Jason
Atlanta, GA