Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Match Function
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match Function arguments | Excel Worksheet Functions | |||
MATCH function | Excel Worksheet Functions | |||
Match function selecting first value it matches on exactly | Excel Worksheet Functions | |||
Need help on index and match function | Excel Worksheet Functions | |||
Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions |