| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vlookupmatch 2 criteria
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query criteria based on a changing criteria list | Excel Discussion (Misc queries) | |||
| =DMIN(database,field,criteria) question about criteria | Excel Discussion (Misc queries) | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| have input box. Need criteria entered to refer to cond. format criteria | Excel Programming | |||
Threaded Mode
