Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Lookup Type Question
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. |
#2
|
|||
|
|||
=D4-IF(COUNTIF(B:B,E4),INDEX(A:A,MATCH(E4,B:B,0)),0)
HTH Jason Atlanta, GA -----Original Message----- 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Question... LookUP | Excel Discussion (Misc queries) | |||
Multiple Criteria Lookup Question | Excel Discussion (Misc queries) | |||
Lookup Question | Excel Worksheet Functions | |||
Lookup and Sort Question | Excel Discussion (Misc queries) | |||
double lookup, nest, or macro? | Excel Worksheet Functions |