Compare data on two spreadsheets.

[Guest]

I am attempting to create a spreadsheet that can be used to show if an order
is complete. Some orders contain only one line and a simple IF statement
tells me wheter or not a each line is complete, =IF(QTY ORDERED=QTY
WRAPPED,"READY","NOT READY") but I am stumped in trying to compare multiple
lines on one order.

For example:

Order 123456 Line 1 QTY ORDERED 5 QTY WRAPPED 5 STATUS READY
Order 123456 Line 2 QTY ORDERED 4 QTY WRAPPED 3 STATUS NOT READY
Order 654321 Line 1 QTY ORDERED 2 QTY WRAPPED 2 STATUS READY
Order 654321 Line 2 QTY ORDERED 6 QTY WRAPPED 6 STATUS READY

In the above example, I would like to return the information in Order 654321
to another spreadsheet indicating that all lines on the the order are
complete and can be shipped.

Hopefully this makes sense and someone can help me out.

Thanks,

DC James

 

[Max]

You've got a response to try out in your later re-post in
..worksheet.functions

 

[Guest]

Thanks Max.

I really appreciate the assistance. Your solution seems to be working well.

Thanks again,

dcjames

 

[Max]

Great to hear that !
Thanks for the feedback ..