Customer requirements
Supplier list
PRESSED BARLEY, 1 KG PKT
I have 2 spreadsheets which one shows what customers want to buy and another which shows the supplier's list.
As the customers required quantity does not match with my list, the spreadsheet is showing an error message #NA.
After amending the description on the customers required list to the same as the supplier list, how should I calculate the quantity for how many packets, and bottles ?
Below is the correct packets and bottles but how to calculate this ?
Pickled radish whole, 1kg - 5 pkt
Anchvy sauce liquid 800ml - 12 bottles
Pressed barley, 1kg - 4 pkt
Supplier list
PRESSED BARLEY, 1 KG PKT
I have 2 spreadsheets which one shows what customers want to buy and another which shows the supplier's list.
As the customers required quantity does not match with my list, the spreadsheet is showing an error message #NA.
After amending the description on the customers required list to the same as the supplier list, how should I calculate the quantity for how many packets, and bottles ?
Below is the correct packets and bottles but how to calculate this ?
Pickled radish whole, 1kg - 5 pkt
Anchvy sauce liquid 800ml - 12 bottles
Pressed barley, 1kg - 4 pkt