Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Help!
I can't seem to get this simply formula to work! Heres an example.... Col A Col B Col C Green Tea £1.00 1st January 2006 Green Tea £1.00 25th October 2005 Green Tea £1.00 5th January 2006 Red Tea £2.00 8th February 2006 White Tea £3.00 20th December 2005 Now in short what I require is a function to look up "Green Tea", then ONLY return the product price value if equal to or greater than 1st January 2006, so the answer would be £2.00. Your help again is always appreciated. Thanks, James. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT Question | Excel Worksheet Functions | |||
SUMPRODUCT question | Excel Worksheet Functions | |||
another sumproduct question | Excel Worksheet Functions | |||
SUMPRODUCT Question... | Excel Discussion (Misc queries) | |||
Question about sumproduct | Excel Discussion (Misc queries) |