Vlookup

jcaptchaos2 · Aug 2, 2007

I have a Vlookup formula that looks at a Concatenate number in a column and then goes to anther spreadsheet to find it in another column that has a concatenate formula in it. I have it set to true to find the closest match but it still returns "0". Can anybody tell me why?

jcaptchaos2 · Aug 2, 2007

Here is the formula I have in the cell,

Code:

=IF(ISNA(VLOOKUP(B6,'Standard op cost'!A$4:R$5730,18,FALSE)*F6),VLOOKUP(B6,'Standard op cost'!A$4:R$5730,18,TRUE)*F6,VLOOKUP(B6,'Standard op cost'!A$4:R$5730,18,FALSE)*F6)

dave3009 · Aug 2, 2007

Hi

Cuold you post the formula you're using and a shot of your data to give us a better idea of what is going on please.

Thanks

Dave

jcaptchaos2 · Aug 2, 2007

<table border = "1" cellspacing = "0" bordercolor="#999999">
<tr><td bgcolor="#C0C0C0"> </td>
<td align="center" bgcolor="#C0C0C0">A</td><td align="center" bgcolor="#C0C0C0">B</td><td align="center" bgcolor="#C0C0C0">C</td><td align="center" bgcolor="#C0C0C0">D</td><td align="center" bgcolor="#C0C0C0">E</td><td align="center" bgcolor="#C0C0C0">F</td><td align="center" bgcolor="#C0C0C0">G</td><td align="center" bgcolor="#C0C0C0">H</td><td align="center" bgcolor="#C0C0C0">I</td><td align="center" bgcolor="#C0C0C0">J</td><td align="center" bgcolor="#C0C0C0">K</td><td align="center" bgcolor="#C0C0C0">L</td><td align="center" bgcolor="#C0C0C0">M</td><td align="center" bgcolor="#C0C0C0">N</td><td align="center" bgcolor="#C0C0C0">O</td><td align="center" bgcolor="#C0C0C0">P</td><td align="center" bgcolor="#C0C0C0">Q</td><td align="center" bgcolor="#C0C0C0">R</td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">3</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF">Code </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RPROD </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">ROPNO </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RWRKC </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">ROPDS </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RBAS </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RSET </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RLAB </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RMAC </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">WLRTE </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">WFOLR </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">WSSUR </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">WSMCR </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RSTAT </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">WDESC </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">ICLOTS </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF">Cost </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF">Prog </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">4</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1256210 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">12562 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">10 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1007 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">CAST/TRIM 1 CAVITY </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">4 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">75 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25.91 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">31.69 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">66.34 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">49.97 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">400 TON BUHLER (CAST & TRIM) </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2.319 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2.319 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">5</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1256212 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">12562 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">12 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2253 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S PETRNT 24 PCS </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">C </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">75 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S PENETRANT INSPECTION </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2.319 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">6</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1256214 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">12562 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">14 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2036 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">GLAS BD BLST FOUNDR SAM </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">80 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25.66 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8.54 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">35.37 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">38.01 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">TR SANDBLASTER </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1.345 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3.664 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">7</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1256215 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">12562 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">15 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2230 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">TUMBLE RINSE FOUNDRY SAMPL </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">500 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25.66 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8.54 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">35.37 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">38.01 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">TUMBLER INLINE </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.215 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3.879 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">8</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1256217 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">12562 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">17 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2253 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S PNTRNT & XRAY SAMP </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">C </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.15 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S PENETRANT INSPECTION </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3.879 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">9</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1256218 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">12562 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">18 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2036 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">GLASS BEAD BLAST </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">80 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25.66 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8.54 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">35.37 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">38.01 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">TR SANDBLASTER </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1.345 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5.223 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">10</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1256219 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">12562 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">19 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2230 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">TUMBLE </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">130 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25.66 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8.54 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">35.37 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">38.01 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">TUMBLER INLINE </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.828 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">6.051 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">11</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1256220 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">12562 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3075 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">DRY </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">130 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25.66 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.85 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">15.65 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8.36 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">HELPER TROWALL </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.389 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">6.440 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">12</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1256225 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">12562 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8003 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">REMOVE VENT RING & POLISH </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">50 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25.66 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8.54 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">35.37 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">38.01 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">REMOVE V-RING&P 2085&2086&2072 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2.152 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8.591 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">13</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1256228 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">12562 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">28 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2192 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">INTERIM FINAL INSPECT </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">18.82 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3.72 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">13.7 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5.63 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">INSPECTION FINAL </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8.591 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">14</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1256230 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">12562 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">30 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2253 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S PENETRANT ALL PARTS </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">C </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1.5 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S PENETRANT INSPECTION </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8.591 </td></tr>
</table>

<table border = "1" cellspacing = "0" bordercolor="#999999">
<tr><td bgcolor="#C0C0C0"> </td>
<td align="center" bgcolor="#C0C0C0">B</td><td align="center" bgcolor="#C0C0C0">C</td><td align="center" bgcolor="#C0C0C0">D</td><td align="center" bgcolor="#C0C0C0">E</td><td align="center" bgcolor="#C0C0C0">F</td><td align="center" bgcolor="#C0C0C0">G</td><td align="center" bgcolor="#C0C0C0">H</td><td align="center" bgcolor="#C0C0C0">I</td><td align="center" bgcolor="#C0C0C0">J</td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">2</td><td rowspan="1" colspan="1" width="121.5" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFF00">Code </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF">NRCID1 </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF">NOPNO </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF">NQTYGD </td><td rowspan="1" colspan="1" width="87" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF">NQTYRJ </td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF">NADTE </td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF">NITEM </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFF00">Month </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFF00">Cost </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">3</td><td rowspan="1" colspan="1" width="121.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5510860 </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">R </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">60 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">864 </td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20070412 </td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">55108 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">04 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">4</td><td rowspan="1" colspan="1" width="121.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5721220 </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">M </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">288 </td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20070103 </td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">57212 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">01 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">5</td><td rowspan="1" colspan="1" width="121.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5373720 </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">M </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">945 </td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20070130 </td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">53737 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">01 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">6</td><td rowspan="1" colspan="1" width="121.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5246651 </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">M </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">51 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1001 </td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">58 </td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20070130 </td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52466 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">01 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">7</td><td rowspan="1" colspan="1" width="121.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5721240 </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">R </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">40 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">224 </td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20070105 </td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">57212 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">01 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">8</td><td rowspan="1" colspan="1" width="121.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5418350 </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">R </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">50 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">576 </td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20070105 </td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">54183 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">01 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">9</td><td rowspan="1" colspan="1" width="121.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5418140 </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">R </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">40 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">960 </td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20070105 </td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">54181 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">01 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">10</td><td rowspan="1" colspan="1" width="121.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1297020 </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">R </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1072 </td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20070105 </td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">12970 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">01 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">11</td><td rowspan="1" colspan="1" width="121.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5430025 </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">R </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">532 </td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20070424 </td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">54300 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">04 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">12</td><td rowspan="1" colspan="1" width="121.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5418310 </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">M </td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">10 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">116 </td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">24 </td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20070417 </td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">54183 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">04 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">18.5488 </td></tr>
</table>

Code:

=IF(ISNA(VLOOKUP(B6,'Standard op cost'!A$4:R$5730,18,FALSE)*F6),VLOOKUP(B6,'Standard op cost'!A$4:R$5730,18,TRUE)*F6,VLOOKUP(B6,'Standard op cost'!A$4:R$5730,18,FALSE)*F6)

jcaptchaos2 · Aug 2, 2007

Formula is in column J on second spread sheet

jcaptchaos2 · Aug 2, 2007

When I use false I get #N/A so it should be working just don't know why it brings back 0

jcaptchaos2 · Aug 2, 2007

Here is the part of the table it would fall into
<table border = "1" cellspacing = "0" bordercolor="#999999">
<tr><td bgcolor="#C0C0C0"> </td>
<td align="center" bgcolor="#C0C0C0">A</td><td align="center" bgcolor="#C0C0C0">B</td><td align="center" bgcolor="#C0C0C0">C</td><td align="center" bgcolor="#C0C0C0">D</td><td align="center" bgcolor="#C0C0C0">E</td><td align="center" bgcolor="#C0C0C0">F</td><td align="center" bgcolor="#C0C0C0">G</td><td align="center" bgcolor="#C0C0C0">H</td><td align="center" bgcolor="#C0C0C0">I</td><td align="center" bgcolor="#C0C0C0">J</td><td align="center" bgcolor="#C0C0C0">K</td><td align="center" bgcolor="#C0C0C0">L</td><td align="center" bgcolor="#C0C0C0">M</td><td align="center" bgcolor="#C0C0C0">N</td><td align="center" bgcolor="#C0C0C0">O</td><td align="center" bgcolor="#C0C0C0">P</td><td align="center" bgcolor="#C0C0C0">Q</td><td align="center" bgcolor="#C0C0C0">R</td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">3</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF">Code </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RPROD </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">ROPNO </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RWRKC </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">ROPDS </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RBAS </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RSET </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RLAB </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RMAC </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">WLRTE </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">WFOLR </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">WSSUR </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">WSMCR </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">RSTAT </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">WDESC </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">ICLOTS </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF">Cost </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF">Prog </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">4</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5246650 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52466 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">50 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2496 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">MACHINE </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">4 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">65 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25.66 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8.54 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">35.37 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">40.86 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">HITACHI SEIKI TF15 TFTWIN </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">10000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1.699 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1.699 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">5</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5246658 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52466 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">58 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2192 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">INTERIM FINAL </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">18.82 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3.72 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">13.7 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5.63 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">INSPECTION FINAL </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">10000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1.699 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">6</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5246660 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52466 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">60 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2215 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S DEBURR/BLAST ARROW CRY </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">C </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.25 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S BLAST </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">10000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1.699 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">7</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5246665 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52466 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">65 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2192 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">INTERIM FINAL </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">18.82 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3.72 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">13.7 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5.63 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">INSPECTION FINAL </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">10000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1.699 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">8</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5246675 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52466 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">75 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2211 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S COPPER/NICKEL PLATE </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">C </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.67 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S PLATE </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">10000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1.699 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">9</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5246676 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52466 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">76 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2192 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">INTERIM FINAL </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">18.82 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3.72 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">13.7 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5.63 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">INSPECTION FINAL </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">10000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1.699 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">10</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5246677 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52466 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">77 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2314 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S PAINT LETTERS </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">C </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.45 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S HANDWORK </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">10000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1.699 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">11</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5246678 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52466 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">78 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2192 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">FINAL INSPECTION </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">18.82 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3.72 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">13.7 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5.63 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">INSPECTION FINAL </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">10000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1.699 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">12</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5246680 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52466 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">80 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2198 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">MOVE TO FG INV </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">17.804 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">14.44 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">10.4 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">6.5 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">MOVE TO FINISHED GDS INVENTORY </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">10000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1.699 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">13</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5267110 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52671 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">10 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1073 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">CAST & TRIM </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">4 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">60 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25.91 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">45.56 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">88.56 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">71.83 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">950 TON SCD/84L BUHLER(C & T) </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3.864 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3.864 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">14</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5267115 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52671 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">15 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2216 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S TUMBLE </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">C </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.35 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">O/S VIBRATORY FINISH </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3.864 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">15</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5267120 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52671 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">20 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2230 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">TUMBLE </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">125 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25.66 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8.54 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">35.37 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">38.01 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">TUMBLER INLINE </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.861 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">4.725 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">16</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5267125 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52671 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">7001 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">DRYER </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">125 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25.66 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8.54 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">35.37 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">38.01 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">INTERMET HI-DENSITY DRY-01 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.861 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5.586 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">17</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5267130 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52671 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">30 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2494 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">LEAK TEST </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">80 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">25.66 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8.54 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">15.65 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5.51 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">SIEMENS LEAK TESTER - ECM2 HSG </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.692 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">6.278 </td></tr>
<tr><td align = "center" bgcolor="#C0C0C0">18</td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5267135 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">52671 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">35 </td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">2192 </td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">FINAL INSPECT </td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">P </td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">18.82 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">3.72 </td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">13.7 </td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">5.63 </td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">1 </td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF">INSPECTION FINAL </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">8000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">0.000 </td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF">6.278 </td></tr>
</table>

jcaptchaos2 · Aug 8, 2007

I figured this out for all that are interested:
Because the range in my formula was set to 5730 rows and my data only contained 864 rows with some formulas extending past the 864 rows it caused it not to bring back the correct data. Once I changed my formuls to 864 rows it worked fine.

Vlookup

jcaptchaos2

Well-known Member

Excel Facts

jcaptchaos2

Well-known Member

dave3009

Well-known Member

jcaptchaos2

Well-known Member

jcaptchaos2

Well-known Member

jcaptchaos2

Well-known Member

jcaptchaos2

Well-known Member

jcaptchaos2

Well-known Member

Similar threads

Forum statistics

Share this page

Vlookup

Well-known Member

Excel Facts

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Well-known Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock