software

Can you or how can you have to lookups?

I have a spreadsheet that has a column with store #'s and a column with part
#'s and a column with Qty's.

I want to compare it to another workbook. See if that spreadsheet is the
same in quantities and part #'s. for that store.

I basically have a file of PO's for store orders which include part#'s and
quatities for stores.

I sent it to the be ordered and we've received the orders and now I want to
see if they there are any orders missing for each store and part # and
compare the qty's as well.

Hope that wasn't confusing.

If you find this store and this part # on this workbook give me the qty.

Thanks B.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions