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 "I
Agree" 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 "I Agree" in the message pane.

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