Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Greetings!
My latest problem goes like this: :) In Columns A,B, &C, I have a product ID, a date, and amount ordered. A1 B1 and C1 look like this: 15016 1/14/2005 70 I am trying to see if those three cells appear anywhere in a lookup table in columns D, E, &F. The range, lets say is (D1:F5) and looks like this: 15016 1/10/2005 70 15022 1/15/2005 70 15016 1/14/2005 35 15035 1/14/2005 90 15016 1/14/2005 50 I was hoping to create a formula in an adjacent cell that would indicate yes or no. The answer to the above scenario would be "no" or "false" because nowhere did anyone order 70 units of Product #15016 on 1/14/2005 Thank you SO much. Michael Saffer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Define a range based on another named range | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
Lookup the latest date in a range so it appears as my result | Excel Discussion (Misc queries) | |||
Lookup with search range start based on position of last blank lin | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |