Hi,


What i am trying to do at the moment is that i have a list of product
and also the dates when they are due : ie

PRODID DUE

1233 12/09/04
1233 13/09/04
1233 14/09/04

when matcing a part using the vlookup function it only matches th
first one. I however need to match a paticular due date. is there an
way to do a form of an if statement:

eg to say; IF( part=1233 and due=12/09/04) then matc

--
Message posted from http://www.ExcelForum.com