How to use Vlookup to retrieve and sum up multiple values in a table.

Hello,
\1
As you can see here, I need a formula that uses the supplier ID in the bottom table and checks for matching supplier IDs in the top table.
Then sum up the (Quantity per re-order)*(unit price) IF the "amount in stock" <= "Re-Order level"

I'm super stressed out about this and would really appreciate some help in this area.

Thanks a lot

Please, rather upload example workbook than picture so we can test.

Maybe

Formula:

Please Login or Register  to view this content.

I tried that formula and it returns a value of 0
Here is the document
http://expirebox.com/download/edaf37...978eb9e5b.html

Thanks so much!

I'm being stupid! This does work.
But can you please explain how it works?

SUMPRODUCT will evaluate each array with two outcomes:

• If you have comparations it will evaluate them into TRUE/FALSE
• If you have numbers it will multiply them

For example:

If your data has:

Please Login or Register  to view this content.

Then SUM of A will look like:

Formula:

Please Login or Register  to view this content.

So it will evaluate into:

Formula:

Please Login or Register  to view this content.

Since TRUE = 1 and FALSE = 0

Formula:

Please Login or Register  to view this content.

Result = 4

Thank you sooo much :D I understand this now.