=INDEX(Sheet2!C:C,MATCH(A2&B2,Sheet2!A1:A100&Sheet 2!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)
"Andri" wrote in message
...
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" wrote:
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" wrote in message
...
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
|