Vlookup

jcaptchaos2

Well-known Member
Joined
Sep 24, 2002
Messages
1,032
Office Version
  1. 365
Platform
  1. Windows
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?
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
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)
 
Upvote 0
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
 
Upvote 0
<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"><font color="#000000">Code </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RPROD </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">ROPNO </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RWRKC </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">ROPDS </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RBAS </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RSET </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RLAB </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RMAC </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WLRTE </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WFOLR </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WSSUR </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WSMCR </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RSTAT </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WDESC </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">ICLOTS </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Cost </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Prog </font></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"><font color="#000000">1256210 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">12562 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1007 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CAST/TRIM 1 CAVITY </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">75 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25.91 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">31.69 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">66.34 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">49.97 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">400 TON BUHLER (CAST & TRIM) </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2.319 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2.319 </font></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"><font color="#000000">1256212 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">12562 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">12 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2253 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S PETRNT 24 PCS </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">C </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">75 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S PENETRANT INSPECTION </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2.319 </font></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"><font color="#000000">1256214 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">12562 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">14 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2036 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">GLAS BD BLST FOUNDR SAM </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">80 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25.66 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8.54 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">35.37 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">38.01 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">TR SANDBLASTER </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1.345 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3.664 </font></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"><font color="#000000">1256215 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">12562 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">15 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2230 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">TUMBLE RINSE FOUNDRY SAMPL </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">500 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25.66 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8.54 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">35.37 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">38.01 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">TUMBLER INLINE </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.215 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3.879 </font></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"><font color="#000000">1256217 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">12562 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">17 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2253 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S PNTRNT & XRAY SAMP </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">C </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.15 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S PENETRANT INSPECTION </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3.879 </font></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"><font color="#000000">1256218 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">12562 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">18 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2036 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">GLASS BEAD BLAST </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">80 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25.66 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8.54 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">35.37 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">38.01 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">TR SANDBLASTER </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1.345 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">5.223 </font></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"><font color="#000000">1256219 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">12562 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">19 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2230 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">TUMBLE </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">130 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25.66 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8.54 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">35.37 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">38.01 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">TUMBLER INLINE </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.828 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">6.051 </font></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"><font color="#000000">1256220 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">12562 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3075 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">DRY </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">130 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25.66 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.85 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">15.65 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8.36 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">HELPER TROWALL </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.389 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">6.440 </font></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"><font color="#000000">1256225 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">12562 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8003 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">REMOVE VENT RING & POLISH </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">50 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25.66 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8.54 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">35.37 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">38.01 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">REMOVE V-RING&P 2085&2086&2072 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2.152 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8.591 </font></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"><font color="#000000">1256228 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">12562 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">28 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2192 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">INTERIM FINAL INSPECT </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">18.82 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3.72 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">13.7 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">5.63 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">INSPECTION FINAL </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8.591 </font></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"><font color="#000000">1256230 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">12562 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">30 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2253 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S PENETRANT ALL PARTS </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">C </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1.5 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S PENETRANT INSPECTION </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8.591 </font></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"><font color="#000000">Code </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">NRCID1 </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">NOPNO </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">NQTYGD </font></td><td rowspan="1" colspan="1" width="87" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">NQTYRJ </font></td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">NADTE </font></td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">NITEM </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFF00"><font color="#000000">Month </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFF00"><font color="#000000">Cost </font></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"><font color="#000000">5510860 </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">R </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">60 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">864 </font></td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20070412 </font></td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">55108 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">04 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></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"><font color="#000000">5721220 </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">M </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">288 </font></td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20070103 </font></td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">57212 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></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"><font color="#000000">5373720 </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">M </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">945 </font></td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20070130 </font></td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">53737 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></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"><font color="#000000">5246651 </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">M </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">51 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1001 </font></td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">58 </font></td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20070130 </font></td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52466 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></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"><font color="#000000">5721240 </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">R </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">40 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">224 </font></td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20070105 </font></td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">57212 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></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"><font color="#000000">5418350 </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">R </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">50 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">576 </font></td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20070105 </font></td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">54183 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></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"><font color="#000000">5418140 </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">R </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">40 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">960 </font></td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20070105 </font></td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">54181 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></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"><font color="#000000">1297020 </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">R </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1072 </font></td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20070105 </font></td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">12970 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">01 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></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"><font color="#000000">5430025 </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">R </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">532 </font></td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20070424 </font></td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">54300 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">04 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></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"><font color="#000000">5418310 </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">M </font></td><td rowspan="1" colspan="1" width="81" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">116 </font></td><td rowspan="1" colspan="1" width="87" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">24 </font></td><td rowspan="1" colspan="1" width="94.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20070417 </font></td><td rowspan="1" colspan="1" width="70.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">54183 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">04 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">18.5488 </font></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)
 
Upvote 0
When I use false I get #N/A so it should be working just don't know why it brings back 0
 
Upvote 0
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"><font color="#000000">Code </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RPROD </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">ROPNO </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RWRKC </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">ROPDS </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RBAS </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RSET </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RLAB </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RMAC </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WLRTE </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WFOLR </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WSSUR </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WSMCR </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">RSTAT </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">WDESC </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">ICLOTS </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Cost </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "center" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">Prog </font></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"><font color="#000000">5246650 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52466 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">50 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2496 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">MACHINE </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">65 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25.66 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8.54 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">35.37 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">40.86 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">HITACHI SEIKI TF15 TFTWIN </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1.699 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1.699 </font></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"><font color="#000000">5246658 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52466 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">58 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2192 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">INTERIM FINAL </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">18.82 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3.72 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">13.7 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">5.63 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">INSPECTION FINAL </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1.699 </font></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"><font color="#000000">5246660 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52466 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">60 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2215 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S DEBURR/BLAST ARROW CRY </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">C </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.25 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S BLAST </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1.699 </font></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"><font color="#000000">5246665 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52466 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">65 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2192 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">INTERIM FINAL </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">18.82 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3.72 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">13.7 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">5.63 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">INSPECTION FINAL </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1.699 </font></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"><font color="#000000">5246675 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52466 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">75 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2211 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S COPPER/NICKEL PLATE </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">C </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.67 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S PLATE </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1.699 </font></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"><font color="#000000">5246676 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52466 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">76 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2192 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">INTERIM FINAL </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">18.82 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3.72 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">13.7 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">5.63 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">INSPECTION FINAL </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1.699 </font></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"><font color="#000000">5246677 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52466 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">77 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2314 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S PAINT LETTERS </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">C </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.45 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S HANDWORK </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1.699 </font></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"><font color="#000000">5246678 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52466 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">78 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2192 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">FINAL INSPECTION </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">18.82 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3.72 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">13.7 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">5.63 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">INSPECTION FINAL </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1.699 </font></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"><font color="#000000">5246680 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52466 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">80 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2198 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">MOVE TO FG INV </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">17.804 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">14.44 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10.4 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">6.5 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">MOVE TO FINISHED GDS INVENTORY </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1.699 </font></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"><font color="#000000">5267110 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52671 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">10 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1073 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">CAST & TRIM </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">60 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25.91 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">45.56 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">88.56 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">71.83 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">950 TON SCD/84L BUHLER(C & T) </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3.864 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3.864 </font></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"><font color="#000000">5267115 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52671 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">15 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2216 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S TUMBLE </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">C </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.35 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">O/S VIBRATORY FINISH </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3.864 </font></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"><font color="#000000">5267120 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52671 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">20 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2230 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">TUMBLE </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">125 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25.66 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8.54 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">35.37 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">38.01 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">TUMBLER INLINE </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.861 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">4.725 </font></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"><font color="#000000">5267125 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52671 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">7001 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">DRYER </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">125 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25.66 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8.54 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">35.37 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">38.01 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">INTERMET HI-DENSITY DRY-01 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.861 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">5.586 </font></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"><font color="#000000">5267130 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52671 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">30 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2494 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">LEAK TEST </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">80 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">25.66 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8.54 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">15.65 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">5.51 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">SIEMENS LEAK TESTER - ECM2 HSG </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.692 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">6.278 </font></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"><font color="#000000">5267135 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">52671 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">35 </font></td><td rowspan="1" colspan="1" width="97.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">2192 </font></td><td rowspan="1" colspan="1" width="375" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">FINAL INSPECT </font></td><td rowspan="1" colspan="1" width="79.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">P </font></td><td rowspan="1" colspan="1" width="75" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="78" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="85.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">18.82 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">3.72 </font></td><td rowspan="1" colspan="1" width="93" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">13.7 </font></td><td rowspan="1" colspan="1" width="102" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">5.63 </font></td><td rowspan="1" colspan="1" width="91.5" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">1 </font></td><td rowspan="1" colspan="1" width="367.5" height="25.5" align = "left" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">INSPECTION FINAL </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">8000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">0.000 </font></td><td rowspan="1" colspan="1" width="96" height="25.5" align = "right" valign = "bottom" bgcolor ="#FFFFFF"><font color="#000000">6.278 </font></td></tr>
</table>
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,513
Messages
6,114,064
Members
448,545
Latest member
kj9

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