I am at a major impass on figuring this out. And where can I get an answer, OZ of course. This has really made me feel like an idiot!

Okay, here is the deal. What I am trying to do is get a "price per" on various items. I am breaking down most things per ounce. I have created a conversion table (J3:L10). I thought that I could use this for a VLOOKUP. This table contains:

Original (Column J)

Convert to (Column K)

Conversion Rate (Column L)

I am trying to populate cells H3:H10 with the formula (one it works). Now the current Packaging is located in D3:D10. I want to use that data to locate in the conversion table (Column J) the same amount.

Also multiply it by the current price (Column G), it needs to be multiplied by the current size (located in Column C) and then the Multi-pack column (Column E).

The end result would use the Concatenate function to display the result along with the "Convert to" that is listed in Column AJ of the Conversion Table.

In addition, as you can tell from the conversion table, I need to convert most items to ounces. So I need to ensure that the calculations are correct.

I have been working on this for a few hours, and well, obviously I have not gotten the result I need, as I am posting. Currently the formula I created is:

[CODE]=SUM(VLOOKUP($D3,$J$3:$L$10,3)*($G3*$C3*$E3),CONCATENATE("per",(VLOOKUP($D3,$J$3:$L$10,2))))[CODE]

And as you can guess, the result is #VALUE! (Thems fightin' words!). I am still getting the hand of how to string multiple functions togather properly. Any help you can offer would be appreciated. Oh, and one other thing. I want to be sure that if the values in Column C, D, E or G are blank, then an error message is NOT displayed. And sometimes the price in Column G is listed as 0, so the cost per in Column H should result in 0, right?

I have attached a sample of my workbook so you can "see" what I am attempting to accomplish. Thanks again!