need to look up the # in column G. If not found value in column H = 0
If found value = sum 8 thru 25 in the same column the number was found. When I try to use the lookup function I get errors. Is there a way to do this.<HTML><HEAD><Script Langage JavaScript><!---
function ViewSource() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource = RetDeleted(HtmlSource);
document.write('<HTML><BODY BGCOLOR=#E0F4EA><CENTER><FORM><TEXTAREA ROWS=30 COLS=90%>');
document.write(HtmlSource);
document.write('</TEXTAREA></FORM></CENTER></BODY></HTML>');
}
function CopyToClipBoard() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource=RetDeleted(HtmlSource);
window.clipboardData.setData("Text",HtmlSource);
alert('Html source of above image\n\nhas been copied to your clip board\n\nJust paste it into Message Body\n\nIf you cannnot paste source from clip board,\n\nclick [View Source] button and paste manually.');
}
function RetDeleted(targetstring) {
if (targetstring.indexOf(unescape('%0D%0A')) > -1) rcode = unescape('%0D%0A')
else if (targetstring.indexOf(unescape('%0A')) > -1) rcode = unescape('%0A')
else rcode = unescape('%0D');
i = 0;
p = '';
while (targetstring.indexOf(rcode,i) != -1) {
m = targetstring.indexOf(rcode,i);
p += targetstring.substring(i,m);
i = m + rcode.length;
}
p += targetstring.substring(i,targetstring.length);
return p;
}</Script></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.42]</FONT></CENTER><HR><SPAN id='ForSubmit'>
</SPAN><CENTER><HR><FORM NAME='form1'><INPUT TYPE='Button' value='Please click this button to send the source to clipbord' onClick='CopyToClipBoard();'><INPUT TYPE='Button' value='View Source' onClick='ViewSource();'></FORM><FONT COLOR=#339966 SIZE=2> This free code was written by Colo and Ivan F Moala:[HtmlMaker 2.42] - 15th May 2003</FONT><FONT COLOR=#339966 SIZE=2>Code mods by Ivan F Moala - 15th May 2003</FONT></HR></BODY></HTML>
If found value = sum 8 thru 25 in the same column the number was found. When I try to use the lookup function I get errors. Is there a way to do this.<HTML><HEAD><Script Langage JavaScript><!---
function ViewSource() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource = RetDeleted(HtmlSource);
document.write('<HTML><BODY BGCOLOR=#E0F4EA><CENTER><FORM><TEXTAREA ROWS=30 COLS=90%>');
document.write(HtmlSource);
document.write('</TEXTAREA></FORM></CENTER></BODY></HTML>');
}
function CopyToClipBoard() {
var HtmlSource;
HtmlSource = document.all.ForSubmit.innerHTML;
HtmlSource=RetDeleted(HtmlSource);
window.clipboardData.setData("Text",HtmlSource);
alert('Html source of above image\n\nhas been copied to your clip board\n\nJust paste it into Message Body\n\nIf you cannnot paste source from clip board,\n\nclick [View Source] button and paste manually.');
}
function RetDeleted(targetstring) {
if (targetstring.indexOf(unescape('%0D%0A')) > -1) rcode = unescape('%0D%0A')
else if (targetstring.indexOf(unescape('%0A')) > -1) rcode = unescape('%0A')
else rcode = unescape('%0D');
i = 0;
p = '';
while (targetstring.indexOf(rcode,i) != -1) {
m = targetstring.indexOf(rcode,i);
p += targetstring.substring(i,m);
i = m + rcode.length;
}
p += targetstring.substring(i,targetstring.length);
return p;
}</Script></HEAD><BODY BGCOLOR=#E0F4EA><CENTER><FONT COLOR=#339966 SIZE=5>[HtmlMaker 2.42]</FONT></CENTER><HR><SPAN id='ForSubmit'>
| aaaaaaaa.htm | |||||||||
|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | |||
| 2 | Listofnumbers | ||||||||
| 3 | SumofSum(down_time) | mach_name | 304028 | ||||||
| 4 | down_reason | 311012 | 311015 | 311013 | 311014 | 308025 | |||
| 5 | Components | 0 | 0 | 0 | 0 | 308026 | |||
| 6 | InsChange | 0 | 0 | 0 | 0 | 308541 | |||
| 7 | Maint | 0 | 0 | 0 | 0 | 310027 | |||
| 8 | MatChange | 0 | 0 | 0 | 0 | 310030 | |||
| 9 | MatDrying | 0 | 351 | 0 | 65.1 | 311012 | |||
| 10 | MatWait | 0 | 0 | 20 | 0 | 311013 | |||
| 11 | MldChange | 0 | 0 | 0 | 0 | 311014 | |||
| 12 | MldClean | 65 | 0 | 0 | 0 | 311015 | |||
| 13 | MldRepair | 0 | 0 | 16 | 0 | 311021 | |||
| 14 | NoLabor | 0 | 0 | 0 | 0 | 311022 | |||
| 15 | NozChange | 98 | 0 | 0 | 0 | 311023 | |||
| 16 | OutofMat | 0 | 34 | 0 | 0 | 311024 | |||
| 17 | Packaging | 0 | 0 | 0 | 0 | 311032 | |||
| 18 | Quality | 0 | 0 | 0 | 0 | 311034 | |||
| 19 | Sampling | 0 | 0 | 0 | 0 | 311035 | |||
| 20 | Scheduling | 0 | 0 | 0 | 0 | 311036 | |||
| 21 | StartUp | 0 | 0 | 0 | 0 | 311037 | |||
| 22 | Unknown | 0 | 292 | 151 | 129.5 | 311038 | |||
| 23 | |||||||||
Sheet1 | |||||||||
