Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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 |