Copy worksheet to Userform

Akashwani

Well-known Member
Joined
Mar 14, 2009
Messages
2,911
Good day,

I hope that I am not asking too much with this one.

I have a workbook with 3 worksheets, 2 containing data and 1 used as a search and display sheet. I enter information into a cell, press enter and the relevant data is displayed in various cells.

I would like to create a userform to do the job of the search/display sheet, this is mainly to make it look more professional!

What do I need to add to the userform? Textboxes, Labels, Command Buttons etc, etc.

How would I go about transferring/copying the following data into a userform?

Thanks

Ak

<TABLE style="WIDTH: 1357pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=1802><COLGROUP><COL style="WIDTH: 23pt; mso-width-source: userset; mso-width-alt: 548" width=30><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 1024" width=56><COL style="WIDTH: 282pt; mso-width-source: userset; mso-width-alt: 6875" width=376><COL style="WIDTH: 41pt; mso-width-source: userset; mso-width-alt: 987" width=54><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 1865" span=5 width=102><COL style="WIDTH: 80pt; mso-width-source: userset; mso-width-alt: 1938" width=106><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 1865" span=2 width=102><COL style="WIDTH: 81pt; mso-width-source: userset; mso-width-alt: 1974" width=108><COL style="WIDTH: 83pt; mso-width-source: userset; mso-width-alt: 2011" width=110><COL style="WIDTH: 144pt; mso-width-source: userset; mso-width-alt: 3510" width=192><COL style="WIDTH: 42pt; mso-width-source: userset; mso-width-alt: 1024" width=56><TBODY><TR style="HEIGHT: 11.25pt; mso-height-source: userset" height=15><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 23pt; HEIGHT: 11.25pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=15 width=30>A1</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 42pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=56>B1</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 282pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl205 width=376>C1</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 41pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=54>D1</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102>E1</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 80pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=106></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 77pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=102></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 81pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=108></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 83pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=110></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 144pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl149 width=192></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; WIDTH: 42pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 width=56>P1</TD></TR><TR style="HEIGHT: 18.75pt; mso-height-source: userset" height=25><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 18.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=25></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl151></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl144>=TODAY()</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl153></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl152></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: #c0c0c0" class=xl154>=NOW()</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl155></TD></TR><TR style="HEIGHT: 24pt; mso-height-source: userset" height=32><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 24pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=32>A3</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl157>=COUNT(Master!A4:A301)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl160>Enter Product code below</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl187>P</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>N</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>M</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>E</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>F</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>S</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>W</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>S</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>S</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl188>G</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl189>R</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22>A5</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl193></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl197>=VLOOKUP(C5,Master,7,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,8,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,9,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,10,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,11,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,12,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,13,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,14,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,15,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl198>=VLOOKUP(C5,Master,16,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl199>=VLOOKUP(C5,Master,17,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl161></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl190>B</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>M</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>O</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>M</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>C</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>M</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>G</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>H</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>L</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl191>S</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl192>P</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21>A7</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl162>Product details</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl200>=VLOOKUP(C5,Master,18,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,19,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,20,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,21,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,22,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,23,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,24,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,25,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,26,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl201>=VLOOKUP(C5,Master,27,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl202>=VLOOKUP(C5,Master,28,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl163>Des</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21>A9</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; FONT-FAMILY: Calibri; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-SIZE: 12pt; BORDER-TOP: #c0c0c0; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl165>=IF(ISNA(VLOOKUP(C5,Master,2,FALSE)),"Incorrect Product code",VLOOKUP(C5,Master,2,FALSE))</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl166>=VLOOKUP(C5,Master,29,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,30,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,31,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,32,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,33,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,34,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,35,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,36,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl167>=VLOOKUP(C5,Master,37,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl168>=VLOOKUP(C5,Master,38,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: yellow; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl195>AL</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl170>=VLOOKUP(C5,Master,39,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,40,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,41,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,42,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,43,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,44,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,45,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,46,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,47,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl172>=VLOOKUP(C5,Master,48,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21>A11</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl173>=VLOOKUP(C5,Master,3,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl170>=VLOOKUP(C5,Master,49,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,50,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,51,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,52,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,53,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,54,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,55,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,56,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,57,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl172>=VLOOKUP(C5,Master,58,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl169>Wa</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl170>=VLOOKUP(C5,Master,59,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,60,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,61,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,62,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,63,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,64,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,65,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,66,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,67,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl172>=VLOOKUP(C5,Master,68,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21>A13</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl173>=VLOOKUP(C5,Master,4,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl170>=VLOOKUP(C5,Master,69,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,70,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,71,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,72,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,73,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,74,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,75,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,76,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,77,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl172>=VLOOKUP(C5,Master,78,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl169>Ar</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl170>=VLOOKUP(C5,Master,79,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,80,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,81,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,82,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,83,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,84,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,85,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,86,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl171>=VLOOKUP(C5,Master,87,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl172>=VLOOKUP(C5,Master,88,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22>A15</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl174>=VLOOKUP(C5,Master,5,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl164></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl175>=VLOOKUP(C5,Master,89,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176>=VLOOKUP(C5,Master,90,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176>=VLOOKUP(C5,Master,91,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176>=VLOOKUP(C5,Master,92,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176>=VLOOKUP(C5,Master,93,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176>=VLOOKUP(C5,Master,94,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176>=VLOOKUP(C5,Master,95,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl176></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 1pt solid" class=xl177></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=20></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl178></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22>A17</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl196>=COUNTA(Ingredients!A4:A200)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl203></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl179>=COUNTIF(Master!C4:C302,"Yes")</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl180>Enter Part code below</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl145>=(C19)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl146>Comprises</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl147></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: #c0c0c0" class=xl147></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: yellow; BORDER-TOP: windowtext 0.5pt solid; BORDER-RIGHT: windowtext 0.5pt solid" class=xl148></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl181></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 16.5pt; mso-height-source: userset" height=22><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 16.5pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=22>A19</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: transparent; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl194></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,3,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,4,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,5,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,6,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,7,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl181></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl181></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext 1pt solid; BORDER-RIGHT: windowtext 1pt solid" class=xl182>Des</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,8,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,9,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,10,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,11,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,12,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl181></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl181></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21>A21</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl156></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; FONT-FAMILY: Calibri; BACKGROUND: #ffc7ce; COLOR: #9c0006; FONT-SIZE: 11pt; BORDER-TOP: #c0c0c0; FONT-WEIGHT: 700; BORDER-RIGHT: windowtext 1pt solid; TEXT-DECORATION: none; mso-pattern: black none; text-underline-style: none; text-line-through: none" class=xl183>=IF(ISNA(VLOOKUP(C19,ing,2,FALSE)),"Incorrect Part code",VLOOKUP(C19,ing,2,FALSE))</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl143></TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext 0.5pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,13,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,14,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,15,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,16,FALSE)</TD><TD style="BORDER-BOTTOM: windowtext 0.5pt solid; BORDER-LEFT: windowtext; BACKGROUND-COLOR: #969696; BORDER-TOP: windowtext; BORDER-RIGHT: windowtext 0.5pt solid" class=xl150>=VLOOKUP(C19,ing,17,FALSE)</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl158></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl159></TD></TR><TR style="HEIGHT: 15.75pt" height=21><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15.75pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=21></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: windowtext 1pt solid; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl184></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl185></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl204></TD><TD style="BORDER-BOTTOM: windowtext 1pt solid; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: #969696; BORDER-TOP: #c0c0c0; BORDER-RIGHT: windowtext 1pt solid" class=xl186></TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; HEIGHT: 15pt; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142 height=20>A23</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142>E23</TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142></TD><TD style="BORDER-BOTTOM: #c0c0c0; BORDER-LEFT: #c0c0c0; BACKGROUND-COLOR: silver; BORDER-TOP: #c0c0c0; BORDER-RIGHT: #c0c0c0" class=xl142>P23</TD></TR></TBODY></TABLE>
 
Hi Bill,

I don't seem to be getting any joy from that,
I'm obviously doing something wrong!!!

The "Partcode" is indeed alpha,
I guess this is going to make a big difference now!

AK
 
Upvote 0
Try removing the VAL

Before
Code:
    Set Product = Sheets("Master").Range("A1:A300").Find(Val(tbLookFor), lookat:=xlWhole, LookIn:=xlValues)

After
Code:
    Set Product = Sheets("Master").Range("A1:A300").Find(tbLookFor, lookat:=xlWhole, LookIn:=xlValues)
 
Upvote 0
Hi Bill,

That works perfectly now,
thank you very much for your time and patience.

Stand by for the next query ;)

Ak
 
Upvote 0

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