Cant get excel forumula to work

I

Ibonic

New Member
Joined
Jun 19, 2011
Messages
30
Hi Im a bit of novice when it comes to excel and im trying to get this forumula to work without success, its for a spreadsheet i use at work.

=IF(A28="Base Field",0,IF(A28="180 Flam (97 sf)",ROUNDUP((C5+F5)*1.1/97,0),IF(A28="630 Soprafix (95 sf)",0,IF(A28="810 Colvent (118 sf)",0,IF(A28="Colph 1500 (193 sf)",0,IF(A28="Elastph PS (147 sf)",ROUNDUP((C5+F5)*1.1/294,0),IF(A28="Sopraply 520 (97 sf)",ROUNDUP((C5+F5)*1.1/97,0),IF(A30="Base Detail",0,IF(A30=" SFFS (147 sf)",,IF(A30="SFS (97 sf)",0,IF(A30="180 Flam (97 sf)",ROUNDUP((C6)*1.2/97,0),"")))))))))))
Im trying to add up the totals from two different cells into one cell

Any help would be greatly appreciated.

Thank you
 
Sort by date Sort by votes
Hello,

Here are two examples, you will see the formula involving the IF(OR() will not update when drop down is changed... I even tried adding a volitile function to the equation.

Have a look at the VLOOKUP()... this does update when changing the dropdown.

Using 2007 the IFERROR() is avail..

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>M</TH><TH>N</TH><TH>O</TH><TH>P</TH><TH>Q</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">26</TD><TD style="TEXT-ALIGN: right"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">List of Propane Items</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Return Value</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">27</TD><TD style="COLOR: #c00000; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">1000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">180 Flam (97 sf)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">28</TD><TD style="COLOR: #c00000; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #e6b9b8; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Elastph PS (147 sf)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">29</TD><TD style="COLOR: #c00000; FONT-WEIGHT: bold">500</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Sopraply 520 (97 sf)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">30</TD><TD style="COLOR: #c00000; FONT-WEIGHT: bold">0</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid"></TD></TR></TBODY></TABLE>
Soprafix​


<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>Q27</TH><TD style="TEXT-ALIGN: left">=$B$28+$B$30</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>Q28</TH><TD style="TEXT-ALIGN: left">=$B$28+$B$30</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>Q29</TH><TD style="TEXT-ALIGN: left">=$B$28+$B$30</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>M27</TH><TD style="TEXT-ALIGN: left">=C5</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>N27</TH><TD style="TEXT-ALIGN: left">=RAND()*0+IF(OR(INDIRECT("A28")={"180 Flam (97 sf)","Elastph PS (147 sf)","Sopraply 520 (97 sf)"}),B28+B30,0)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>M28</TH><TD style="TEXT-ALIGN: left">=F5</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>N28</TH><TD style="TEXT-ALIGN: left">=IFERROR(VLOOKUP(A28,P27:Q29,2,FALSE),0)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>M29</TH><TD style="TEXT-ALIGN: left">=C6</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>M30</TH><TD style="TEXT-ALIGN: left">=F6</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
I have included the M:M column for reference purposes.

-Jeff
 
Upvote 0

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
repairman615 said:
Hello,

Here are two examples, you will see the formula involving the IF(OR() will not update when drop down is changed... I even tried adding a volitile function to the equation.

Have a look at the VLOOKUP()... this does update when changing the dropdown.

Using 2007 the IFERROR() is avail..

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>M</TH><TH>N</TH><TH>O</TH><TH>P</TH><TH>Q</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">26</TD><TD style="TEXT-ALIGN: right"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">List of Propane Items</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #d7e4bc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Return Value</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">27</TD><TD style="COLOR: #c00000; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">1000</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f2dddc; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">180 Flam (97 sf)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">28</TD><TD style="COLOR: #c00000; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">0</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #e6b9b8; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19</TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Elastph PS (147 sf)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">29</TD><TD style="COLOR: #c00000; FONT-WEIGHT: bold">500</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-RIGHT: black 1px solid"></TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">Sopraply 520 (97 sf)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">19</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">30</TD><TD style="COLOR: #c00000; FONT-WEIGHT: bold">0</TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid"></TD></TR></TBODY></TABLE>
Soprafix​


<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>Q27</TH><TD style="TEXT-ALIGN: left">=$B$28+$B$30</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>Q28</TH><TD style="TEXT-ALIGN: left">=$B$28+$B$30</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>Q29</TH><TD style="TEXT-ALIGN: left">=$B$28+$B$30</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>M27</TH><TD style="TEXT-ALIGN: left">=C5</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>N27</TH><TD style="TEXT-ALIGN: left">=RAND()*0+IF(OR(INDIRECT("A28")={"180 Flam (97 sf)","Elastph PS (147 sf)","Sopraply 520 (97 sf)"}),B28+B30,0)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>M28</TH><TD style="TEXT-ALIGN: left">=F5</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>N28</TH><TD style="TEXT-ALIGN: left">=IFERROR(VLOOKUP(A28,P27:Q29,2,FALSE),0)</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>M29</TH><TD style="TEXT-ALIGN: left">=C6</TD></TR><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>M30</TH><TD style="TEXT-ALIGN: left">=F6</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
I have included the M:M column for reference purposes.

-Jeff
Click to expand...

Hi Jeff thanks for your help on this, but I dont know how to apply this to my spreadsheet so it works, i tried all different variations of it, as I said Im a novice at this
 
Upvote 0
You can try the formula

<TABLE style="WIDTH: 531pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=708><COLGROUP><COL style="WIDTH: 531pt; mso-width-source: userset; mso-width-alt: 12946" width=708><TBODY><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2dddc; WIDTH: 531pt; HEIGHT: 16.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=22 width=708>=IF(OR(INDIRECT("A28")={"180 Flam (97 sf)","Elastph PS (147 sf)","Sopraply 520 (97 sf)"}),B28+B30,0)</TD></TR></TBODY></TABLE>

in cell B34

or, here is the method I am favoring:

paste the table into P26:Q29

then use the formula
<TABLE style="WIDTH: 531pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=708><COLGROUP><COL style="WIDTH: 531pt; mso-width-source: userset; mso-width-alt: 12946" width=708><TBODY><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #e6b9b8; WIDTH: 531pt; HEIGHT: 16.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl65 height=22 width=708>=IFERROR(VLOOKUP(A28,P27:Q29,2,FALSE),0)</TD></TR></TBODY></TABLE>
in cell B34
 
Upvote 0
repairman615 said:
You can try the formula

<TABLE style="WIDTH: 531pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=708><COLGROUP><COL style="WIDTH: 531pt; mso-width-source: userset; mso-width-alt: 12946" width=708><TBODY><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #f2dddc; WIDTH: 531pt; HEIGHT: 16.5pt; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl63 height=22 width=708>=IF(OR(INDIRECT("A28")={"180 Flam (97 sf)","Elastph PS (147 sf)","Sopraply 520 (97 sf)"}),B28+B30,0)</TD></TR></TBODY></TABLE>

in cell B34

or, here is the method I am favoring:

paste the table into P26:Q29

then use the formula
<TABLE style="WIDTH: 531pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=708><COLGROUP><COL style="WIDTH: 531pt; mso-width-source: userset; mso-width-alt: 12946" width=708><TBODY><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #e6b9b8; WIDTH: 531pt; HEIGHT: 16.5pt; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl65 height=22 width=708>=IFERROR(VLOOKUP(A28,P27:Q29,2,FALSE),0)</TD></TR></TBODY></TABLE>
in cell B34
Click to expand...

Hi Jeff, it seems to work, but not correctly, plus if you change your quanities in C5 or C7 then it doesnt work, also if you change to add up different values from the boxes, like choose the Elasph with the 180 flam it should total only 15, where the total stays at a constant 19
 
Upvote 0
Do you mean the Elasph and 180 like:

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">28</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Elastph PS (147 sf)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">29</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Detail Primer</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">30</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">180 Flam (97 sf)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">31</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Roof Pen Detail</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">32</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Cap Field</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">33</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Cap Detail</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">34</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">PROPANE</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">15</TD></TR></TBODY></TABLE>
Soprafix​

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>B</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">34</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">15</TD></TR></TBODY></TABLE>
Soprafix​


<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>B34</TH><TD style="TEXT-ALIGN: left">=IFERROR(VLOOKUP(A28,P27:Q29,2,FALSE),0)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
Seems to work for me, or are you using the formula with the IF(OR))??

If so this one will not update upon changing the drop box, however if you select the cell click in the formula then press enter it will update.
 
Upvote 0
repairman615 said:
Do you mean the Elasph and 180 like:

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">28</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Elastph PS (147 sf)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">8</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">29</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Detail Primer</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">30</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">180 Flam (97 sf)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">7</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">31</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Roof Pen Detail</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">32</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Cap Field</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">33</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Cap Detail</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">34</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">PROPANE</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">15</TD></TR></TBODY></TABLE>
Soprafix​

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>B</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">34</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">15</TD></TR></TBODY></TABLE>
Soprafix​


<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>B34</TH><TD style="TEXT-ALIGN: left">=IFERROR(VLOOKUP(A28,P27:Q29,2,FALSE),0)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
Seems to work for me, or are you using the formula with the IF(OR))??

If so this one will not update upon changing the drop box, however if you select the cell click in the formula then press enter it will update.
Click to expand...

Thats what i mean, yes selecting Elastph and and 180 flam, i tried it with the Iferror and it didnt work for me, i guess im not putting it into the spreadsheet properly, do you mind putting it into the spreadsheet and posting it on 4shared so i can see it, Im not really sure now to make it work
thanks
 
Upvote 0
Sure,

Here is what I am working with:

<TABLE style="WIDTH: 230pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=307><COLGROUP><COL style="WIDTH: 230pt; mso-width-source: userset; mso-width-alt: 11227" width=307><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #eaf1dd; WIDTH: 230pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20 width=307>4Shared.. Modified Version</TD></TR></TBODY></TABLE>
 
Upvote 0
repairman615 said:
Sure,

Here is what I am working with:

<TABLE style="WIDTH: 230pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=307><COLGROUP><COL style="WIDTH: 230pt; mso-width-source: userset; mso-width-alt: 11227" width=307><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: #eaf1dd; WIDTH: 230pt; HEIGHT: 15pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl64 height=20 width=307>4Shared.. Modified Version</TD></TR></TBODY></TABLE>
Click to expand...

Hi Jeff now the only problem I see now is that if you choose 180 Flam in A30 by itself it doesnt register in A34
 
Upvote 0
Hello,

If I understand correctly, add a reference to B30 at the end of the formula:

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">28</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #00B050;;">Base Field</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #C00000;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #00B050;;">Detail Primer</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #C00000;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #00B050;;">SFFS (147 sf)</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #C00000;;">5</td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #00B050;;">Roof Pen Detail</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #C00000;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #00B050;;">Cap Field</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #C00000;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #00B050;;">Cap Detail</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;color: #C00000;;">0</td></tr><tr ><td style="color: #161120;text-align: center;">34</td><td style="font-weight: bold;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">PROPANE</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Soprafix</p><br /><br />

The above shows "Base Field" B28, and "SFFS..." B30.


<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">34</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">5</td></tr></tbody></table><p style="width:4.8em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">Soprafix</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B34</th><td style="text-align:left">=IFERROR(<font color="Blue">VLOOKUP(<font color="Red">A28,P27:Q29,2,FALSE</font>),B30</font>)</td></tr></tbody></table></td></tr></table><br />

The above shows the amended formula.

Are there any other places entries that would need to be added into this formula?

-Jeff
 
Upvote 0
repairman615 said:
Hello,

If I understand correctly, add a reference to B30 at the end of the formula:

Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">28</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Base Field</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">29</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Detail Primer</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">30</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">SFFS (147 sf)</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">31</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Roof Pen Detail</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">32</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Cap Field</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">33</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; COLOR: #00b050; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Cap Detail</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-LEFT: black 1px solid; COLOR: #c00000; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">0</TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">34</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">PROPANE</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5</TD></TR></TBODY></TABLE>
Soprafix​




The above shows "Base Field" B28, and "SFFS..." B30.


Excel 2007<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #e0e0f0" width=25><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH></TH><TH>B</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">34</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; BORDER-RIGHT: black 1px solid">5</TD></TR></TBODY></TABLE>
Soprafix​


<TABLE style="BORDER-BOTTOM: black 2px solid; BORDER-LEFT: black 2px solid; PADDING-BOTTOM: 0.4em; BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 0.4em; PADDING-RIGHT: 0.4em; BORDER-COLLAPSE: collapse; BORDER-TOP: black 2px solid; BORDER-RIGHT: black 2px solid; PADDING-TOP: 0.4em" rules=all cellPadding=2 width="85%"><TBODY><TR><TD style="PADDING-BOTTOM: 6px; PADDING-LEFT: 6px; PADDING-RIGHT: 6px; PADDING-TOP: 6px">Worksheet Formulas<TABLE style="BORDER-BOTTOM: #a6aab6 1px solid; TEXT-ALIGN: center; BORDER-LEFT: #a6aab6 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #a6aab6 1px solid; BORDER-RIGHT: #a6aab6 1px solid" rules=all cellPadding=2 width="100%"><THEAD><TR style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120"><TH width=10>Cell</TH><TH style="TEXT-ALIGN: left; PADDING-LEFT: 5px">Formula</TH></TR></THEAD><TBODY><TR><TH style="BACKGROUND-COLOR: #e0e0f0; COLOR: #161120" width=10>B34</TH><TD style="TEXT-ALIGN: left">=IFERROR(VLOOKUP(A28,P27:Q29,2,FALSE),B30)</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>


The above shows the amended formula.

Are there any other places entries that would need to be added into this formula?

-Jeff
Click to expand...

These are the following entries that would need propane, only these products:

A28 = 180 Flam, Elastph PS, Sopraply 520 (these 3 only in this list)
A30= 180 Flam (only this one in this list)
A31= 180 Flam
A32= All entries (all 6 products would need propane)
A33= All entries (all 6 products would need propane)

Thank you for your efforts
 
Upvote 0
You must log in or register to reply here.

Forum statistics

Threads
1,224,621
Messages
6,179,929
Members
452,949
Latest member
beartooth91

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top