Hi

I've read various articles on the web about how to use INDEX and MATCH to return a value using several criteria but I just cant seem to get mine to work! Driving me mad

It would be a massive help to me if someone can help me sort this

Ok, I have a list of Purchase order numbers and the quantities of item ordered on that particular order number

On a seperate sheet I have a list of thousands of invoices that has the purchase order number, invoiced value and invoiced quantity.

Now, as some of the purchase order numbers are used more than once (on both sheets) the only way I can match the invoice VALUE to the correct PO is by matching both the Purchase order number AND the quantity.

So, I used the following forumula:

{=INDEX(Sheet2!O1:O500000,MATCH(1,(Sheet2!B1:B500000=A2)*(Sheet2!C2:C500000=B2),0))}

Explanation:
Sheet 2 is the sheet with the invoice informaton on, O is the column in which the invoice values are (The value I wish to return)
Column B in sheet 2 is where the purchase order number is
Column C in sheet 2 is where the quantity is
Cell A2 is the PO number I want to find a match for
Cell B2 is the quantity I want to find a match for

Matching both the PO number and PO quantity against the invoiced PO number and invoiced quantity will then tell me how much was invoiced against that particular PO

Just keep getting a #REF or #NA error!

Massive thank you to anyone who helps!