Try this:
=INDEX(Orders!D1:D7,MATCH(C3,Orders!A1:A7,MATCH(C5 ,Orders!B1:B7,MATCH(A8,Orders!C1:C7))))

This is a good resource:
http://www.contextures.com/xlFunctions03.html

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Nicky" wrote:

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