Equation that depends on table (not sure how to explain this in a title)

**adwhitle** · 10-30-2013, 01:12 PM

Below is a sample of information that I am working on. Each item such as 600BF8, 600ER, 600__.... is a item that has a specific density which is below the information table. The values to the right of each item (600BF8) is in weight. These weights need to be converted into mililiters. The equation is ((value/density)*(interior or exterior value))/.077.

Is there a way to easily put all this together? This database ranges from 200-1100 rows so I would rather not always go into each field and manually put the formula in due to the items changing and the density changing based on which item. Could anyone give me any help as to which function I should try to use? I can give any more clarification if it is needed. I know this is not the best explanation.

Interior 600ER 0.208821 600NO8 0.576478 600WW 1.856872 600YO 3.102509
Exterior 600BF8 0.45 600ER 0.32 600WW 3.42 600YO 1.55
Exterior 600BF8 0.518296 600RY 0.150374 600WW 3.961619 600YO 1.114391
Interior 600ER 0.433488 600NO8 0.282409 600WW 3.762551 600YO 1.266231
Interior 600NO8 0.061139 600RY 0.209278 600WW 5.155136 600YO 1.609761
Exterior 600ER 0.055878 600NO8 0.026207 600RY 0.083645 600WW 4.981218 600YO 0.597733
Interior 600BF8 0.296899 600NO8 0.99404 600RY 0.793965 600YO 1.915097
Exterior 600ER 0.360956 600NO8 0.501926 600WW 4.419353 600YO 0.462439
Exterior 600NO8 0.218182 600RO8 0.15836 600WW 4.531842 600YO 0.836296

Density
BF8 1.9
NO8 1.955
RO8 2.15
LM8 1.82
ER 1.25
RY 1.9
YO 1.79
WW 2.045

values for exterior/interior
Exterior=41.66
Interior=49.65

Thanks for any help.

**Tony Valko** · 10-30-2013, 03:14 PM

Can you take the data in your post and put it in a sample file and show us what result(s) you expect?

**coolfundaz** · 10-30-2013, 03:34 PM

Hi,

Can you add the data in a sample excel and let us know what is the result you desire.
Just don't want to hazard a guess and spend time on something that may be totally different from what you're looking for

**adwhitle** · 11-04-2013, 10:15 AM

Here is a sample. The first sheet labeld raw data is the info from the first post. The second sheet is the finished data with the formula. I can do it a certain way but it is time consuming to filter each code and drag the formula down. Each item has to reference the density table in the bottom of sheet labeled "raw data"