Matching dates and Return ID Number

[nycard64]

I have a spread sheet where I am trying to match up dates + or - a few days and then return the WC ID number from the WETCLEAN Sheet to the JO01 Sheet Wet Clean Column. I need to match up some info. I am using a formula that I have used in the past but am having difficulty getting it to work here. Any help would be appreciated. Thanks.

JO01

<table style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 65px"> <col style="WIDTH: 90px"> <col style="WIDTH: 70px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td> </td> <td>A</td> <td>B</td> <td>C</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td style="FONT-SIZE: 9pt"> </td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">JO01</td> <td style="FONT-SIZE: 9pt"> </td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td style="FONT-SIZE: 9pt"> </td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">L1 Thk Std</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">WET Clean</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/28/2010</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">1.57</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">36</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">4/30/2010</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">1.96</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">0</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">5/2/2010</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">2.06</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">0</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">5/2/2010</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">1.25</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">0</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">5/2/2010</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">2.12</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">0</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">5/2/2010</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">2.1</td> <td style="TEXT-ALIGN: center; FONT-SIZE: 9pt">0</td></tr></tbody></table>
<table style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"> <tbody> <tr> <td>Spreadsheet Formulas</td></tr> <tr> <td> <table style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"> <td>Cell</td> <td>Formula</td></tr> <tr> <td>C4</td> <td>{=MAX(IF((WETCLEAN!A$2:$A$40=B2)*(WETCLEAN!$B$2:$B$40>A4-2)*(WETCLEAN!$C$2:$C$40<A4+2),WETCLEAN!E2:E40,0))}</td></tr> <tr> <td>C5</td> <td>{=MAX(IF((WETCLEAN!A$2:$A$40=B3)*(WETCLEAN!$B$2:$B$40>A5-2)*(WETCLEAN!$C$2:$C$40<A5+2),WETCLEAN!E3:E41,0))}</td></tr> <tr> <td>C6</td> <td>{=MAX(IF((WETCLEAN!A$2:$A$40=B4)*(WETCLEAN!$B$2:$B$40>A6-2)*(WETCLEAN!$C$2:$C$40<A6+2),WETCLEAN!E4:E42,0))}</td></tr> <tr> <td>C7</td> <td>{=MAX(IF((WETCLEAN!A$2:$A$40=B5)*(WETCLEAN!$B$2:$B$40>A7-2)*(WETCLEAN!$C$2:$C$40<A7+2),WETCLEAN!E5:E43,0))}</td></tr> <tr> <td>C8</td> <td>{=MAX(IF((WETCLEAN!A$2:$A$40=B6)*(WETCLEAN!$B$2:$B$40>A8-2)*(WETCLEAN!$C$2:$C$40<A8+2),WETCLEAN!E6:E44,0))}</td></tr> <tr> <td>C9</td> <td>{=MAX(IF((WETCLEAN!A$2:$A$40=B7)*(WETCLEAN!$B$2:$B$40>A9-2)*(WETCLEAN!$C$2:$C$40<A9+2),WETCLEAN!E7:E45,0))}</td></tr></tbody></table></td></tr> <tr> <td>Formula Array:
Produce enclosing { } by entering
formula with CTRL+SHIFT+ENTER!</td></tr></tbody></table>

Excel tables to the web >> Excel Jeanie HTML 4
WETCLEAN

<table style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Calibri,Arial; FONT-SIZE: 11pt" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="WIDTH: 30px; FONT-WEIGHT: bold"> <col style="WIDTH: 63px"> <col style="WIDTH: 69px"> <col style="WIDTH: 93px"> <col style="WIDTH: 213px"> <col style="WIDTH: 64px"></colgroup> <tbody> <tr style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"> <td> </td> <td>A</td> <td>B</td> <td>C</td> <td>D</td> <td>E</td></tr> <tr style="HEIGHT: 29px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">Tool</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">Date</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">Wafer Count at PM</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">WET Clean</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">WC ID</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">J003</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">4/16/2010</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">20339</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">Wet clean</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">1</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">JO02</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">4/24/2010</td> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff0000; FONT-FAMILY: Arial; COLOR: #ffffff; FONT-SIZE: 9pt">?</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">Showerhead change/return from idle</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">2</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">JO01</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">4/26/2010</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">14797</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">Showerhead change</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">3</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">J004</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">4/30/2010</td> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ff0000; FONT-FAMILY: Arial; COLOR: #ffffff; FONT-SIZE: 9pt">20842</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">Wet clean</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">4</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">JO02</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">5/17/2010</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">649</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">Wet clean</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">5</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">J003</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">6/3/2010</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">17994</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">Wet clean</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">6</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">JO02</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">6/7/2010</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">5610</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">Wet clean</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">7</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">JO02</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">6/14/2010</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">1133</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">Wet clean</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">8</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">J004</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">6/19/2010</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">19395</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">Wet clean</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">9</td></tr> <tr style="HEIGHT: 15px"> <td style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">JO01</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">6/26/2010</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">18304</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">Wet clean</td> <td style="TEXT-ALIGN: center; FONT-FAMILY: Arial; FONT-SIZE: 9pt">10</td></tr></tbody></table>
<table style="BORDER-BOTTOM-STYLE: groove; BORDER-BOTTOM-COLOR: #00ff00; BORDER-RIGHT-STYLE: groove; BACKGROUND-COLOR: #fffcf9; BORDER-TOP-COLOR: #00ff00; FONT-FAMILY: Arial; BORDER-TOP-STYLE: groove; COLOR: #000000; BORDER-RIGHT-COLOR: #00ff00; FONT-SIZE: 10pt; BORDER-LEFT-STYLE: groove; BORDER-LEFT-COLOR: #00ff00"> <tbody> <tr> <td>Spreadsheet Formulas</td></tr> <tr> <td> <table style="FONT-FAMILY: Arial; FONT-SIZE: 9pt" border="1" cellpadding="2" cellspacing="0"> <tbody> <tr style="BACKGROUND-COLOR: #cacaca; FONT-SIZE: 10pt"> <td>Cell</td> <td>Formula</td></tr> <tr> <td>E3</td> <td>=E2+1</td></tr> <tr> <td>E4</td> <td>=E3+1</td></tr> <tr> <td>E5</td> <td>=E4+1</td></tr> <tr> <td>E6</td> <td>=E5+1</td></tr> <tr> <td>E7</td> <td>=E6+1</td></tr> <tr> <td>E8</td> <td>=E7+1</td></tr> <tr> <td>E9</td> <td>=E8+1</td></tr> <tr> <td>E10</td> <td>=E9+1</td></tr> <tr> <td>E11</td> <td>=E10+1</td></tr></tbody></table></td></tr></tbody></table>

Excel tables to the web >> Excel Jeanie HTML 4