I am trying to get the values for a delivery note. I have all the data in a
seperate worksheet called ORDERS as below

Date Part No Depot Qty
11/11/09 F13624 4 200
12/11/09 F13625 5 300

The formula I have used is:

=INDEX(ORDERS!$D:$D,MATCH($C$3,ORDERS!$A:$A,0),MAT CH(C$5,ORDERS!$B:$B,0),MATCH($A8,ORDERS!$C:$C,0))

This keeps returning a #N/A error

On my delivery note

C3 holds the date
C5 holds the part no
A8 holds the depot

I want it to match all 3 criteria and return the qty.


Get again I need the experts, its probably something really silly..

Thank you in advance.

Nicky