Match Function

[Andri]

Dear All,
I would like to know the back order status of item purchased.
Sheet1 : about the purchase file contains fields such as PO#, PN, Qty
Bought, Price,etc
Sheet2 : about the items received contains fields such as PO#, PN, Qty
Received,etc

Please advice how to compare Qty Bought - Qty Received, based on Match on
PO# AND PN in Sheet1 AND Sheet2.

Thank you.
Andri

 

[Bob Phillips]

On the Received sheet

=VLOOKUP(A2,Sheet1!$A$2:$C$100,3,False)

to get the quantity bough

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Andri]

Dear Bob,

I would like to get the Qty Received besides the Qty Bought in Sheet 1, ONLY
IF the PO# AND PN in Sheet1 = PO# AND PN in Sheet2.

Thank you in re-advising me.

Brgds,andri

 

[Bob Phillips]

=INDEX(Sheet2!C:C,MATCH(A2&B2,Sheet2!A1:A100&Sheet2!B1:B100,0))

which is an array formula, so commit with Ctrl-Shift-Enter


--

HTH

RP
(remove nothere from the email address if mailing direct)