Stuck! Exact Values

[morrone_mike]

I have created a database of product type codes in access and transferred it to a table in excel. The end game is when I receive an order form it will upload in my estimate sheet. The problem that I am having is attempting to use the sum of a given range if the product code matches the one in the table. I can easily do so if I am talking about one cell but this is for multiple cells. The reason I am using the table is because it is broken down in sections such as "framing" "siding" "trim" etc. The exact value just brings back true or false and I cannot seem to find the best way to go about it. Any insight would be greatly appreciated, thank you!

[nathansav]

can you attach a sample?

[morrone_mike]

I attached a test page this just has a random table that would be uploaded from the PDF bid that the lumber company gives and then there is a small table at the bottom that just has random product codes with random sections. So basically what I am looking for is a section for say framing and it will use the corresponding product codes for framing and what the prices would be for those codes. Thanks!

[Saarang84]

Hi Mike,

Welcome to the forum.
I couldn't interpret your requirement from your test worksheet. Could you please post how your output would be for this input?

[alansidman]

First you will need to unmerge all the cells to make this work.

Then you will need a vlookup in F22 =VLOOKUP(E22,$C$2:$AA$20,23,FALSE)

And copy it down. Look at this link to see how vlookup works

http://www.techonthenet.com/excel/formulas/vlookup.php

[AlKey]

Please see attached file.

[morrone_mike]

Sorry the columns did not transfer through, the last column on the right AF2:AJ20 is the sum range those are the finals prices of the product. The table in the bottom is the sections "framing", "siding", "trim" etc. So basically what is needed is if the product code in C2:J20 matches the product code in the table if it is in the "framing" section then it will pull the corresponding price in AF2:AJ20. So in the end I will have a section for say framing and this will pull each product code in the top table that is known to be framing and add the prices all together. Sorry this is all semi new for me so I apologize if that is not the best way to explain!

[AlKey]

I suggest you upload a file where it shows what the expected results should look like. The explanation you provided, at least for me, is very difficult to follow.

[Saarang84]

Hi Michel,

From what I could understand from the OP's explanation so far, he would need a SUMPRODUCT formula (on prices column) one each for the sections Framing, Siding, Trim, etc. But unfortunately, the sample workbook that he has posted contains incomplete data

[AlKey]

Hi Michel,

LOL!!!, Michel or Michel de Montaigne was a prominent French writer and philosopher who died in 1592 (422 years ago)

[Saarang84]

LOL!!!, Michel or Michel de Montaigne was a prominent French writer and philosopher who died in 1592 (422 years ago)

Sorry !! Didn't know that, thought it was your name...