Function Help for UDF needed

[DougStroud]

Here is a block of code from a UDF that was provided to me-
This looks in a table to validate size values. But what I would like to do is change the condition slightly to validate it in column 1 and use the value adjacent in column 2.
Here is the original block of code:

Else
        'Check text sizes
        Set c = Range("Sizes").Find(tmp(x))
        If Not c Is Nothing Then
        LVS = tmp(x)
        Else
            LVS = ""
        End If

I was thinking that adding a .Resize(,2) would accomplish this, but it fails.

Else
        'Check text sizes
        Set c = Range("Sizes").Find(tmp(x))
        If Not c Is Nothing Then
        LVS = tmp(x).Resize(,2)
        Else
            LVS = ""
        End If

Thanks,

Doug

 

[jindon]

Not sure
Is this what you mean?

Dim myRng As Range

Else
        'Check text sizes
        Set c = Range("Sizes").Find(tmp(x))
        If Not c Is Nothing Then
             Set myRng = c.Resize(,2)
        Else
             LVS = ""
        End If

It is hard to say anything without knowing wha tyou are trying to do...
BTW how big is the "size" ?

 

[DougStroud]

Thanks Jindon,
Here is the entire Function: (What the Function is Doing).
The function is looking at a text string and extracting the Last Value, a valid Last Value. Which is the size of the item, and this can be either a numerical or a text value. It could be a whole number, mixed number or fractional number. The function is used because the text string in a lot of cases does not have a size and it evaluates this too.
When you ask how big the "size" is, I do not know what you mean. But that may be because you do not know what I am doing,
It is looking in a size table, a range named "Sizes", for valid values. But I have some where they are valid by nature, but want to replace them, i.e. Large, Lrg, L would be replaced w/ Lg. I have all the valid values in a table w/ a proper size adjacent to it.
If the function is incapable of handling this, I can always do a find and replace, but trying to avoid adding one more process to this.

Function LVS(Data As Range)
    Dim tmp, Siz, x As Long, c As Range
    tmp = Split(Data)
    x = UBound(tmp)
    If InStr(1, tmp(x), "#") > 0 Or InStr(1, tmp(x), "-") > 0 Then
        LVS = ""
        Exit Function
    End If
    If IsNumeric(Right(tmp(x), 1)) Then
        'Number sizes
        Siz = tmp(x)
        If InStr(Siz, "/") > 0 And IsNumeric(Right(Siz, 1)) Then
            If IsNumeric(tmp(x - 1)) Then
                Siz = tmp(x - 1) & " " & tmp(x)
            End If
        End If
        LVS = Siz
    Else
        'Check text sizes
        Set c = Range("Sizes").Find(tmp(x))
        If Not c Is Nothing Then
        LVS = tmp(x)
        Else
            LVS = ""
        End If
    End If
    If UCase(Right(tmp(x), 2)) = "CM" Then
        LVS = tmp(x)
    End If
End Function



If the function is incapable of

The original developer of the function is on vacation for another week and I just discovered this, and as I wrote previously I am hoping to finish this in the next day or two.

 

[jindon]

Doug,

If you don't mind, can you post the sample of the "text" and tell us what you want to do with it and the result how you want?

 

[DougStroud]

Hello Jindon,
Sure-- The following table contains two columns, left column is the valid data that the Function compares and populates my sheet. I would rather it validate it and take the value to the adjacent cell to the right of it to standardize my size values. Like a Vlookup, but use the Function above. This function is splitting the data from the second table below and compares it to the table and then places it in the sheet.

MasterImportSheetWebStore.xls
	A	B	C	D
498	L	Lg
499	L/Xl
500	LARGE	Lg
501	LG	Lg
502	Lg/Xl
503	LRG	Lg
504	M	Md
505	MD	Md
506	MED	Md
507	MEDIUM	Md
508	S	Sm
509	S/M	Sm/Md
510	SM	Sm
511	Sm/Md	Sm/Md
512	SMALL	Sm
513	SML	Sm
514	XL	Xl
515	Xlarge	Xl
516	XLG	Xl
517	XLRG	Xl
518	XS	Xs
519	Xsml	Xs
520	XXL	2x
521	XXS	XXS
Table

<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis/colo/popup.js"></SCRIPT><CENTER><TABLE cellSpacing=0 cellPadding=0 align=center><TBODY><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=#0c266b colSpan=11><TABLE width="100%" align=center border=0><TBODY><TR><TD align=left><FONT color=white>Microsoft Excel - MasterImportSheetWebStore.xls</FONT></TD><TD style="FONT-SIZE: 9pt; COLOR: #ffffff; FONT-FAMILY: caption" align=right>___Running: 11.0 : OS = Windows XP</FONT></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; HEIGHT: 25px" bgColor=#d4d0c8 colSpan=11><TABLE width="100%" align=center border=0 VALIGN="MIDDLE"><TBODY><TR><TD style="FONT-SIZE: 10pt; COLOR: #000000; FONT-FAMILY: caption">(<U>F</U>)ile (<U>E</U>)dit (<U>V</U>)iew (<U>I</U>)nsert (<U>O</U>)ptions (<U>T</U>)ools (<U>D</U>)ata (<U>W</U>)indow (<U>H</U>)elp (<U>A</U>)bout</TD><TD vAlign=center align=right><FORM name=formCb658016><INPUT onclick='window.clipboardData.setData("Text",document.formFb431795.sltNb305190.value);' type=button value="Copy Formula" name=btCb074442></FORM></TD></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid" bgColor=white colSpan=11><TABLE border=0><TBODY><TR><FORM name=formFb431795><TD style="WIDTH: 60px" align=middle bgColor=white><SELECT onchange="document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value" name=sltNb305190><OPTION value='=IF(C68="","",IF(LEFT(C69,2)="~P","",IF(AND(J68="",LEFT(C68,2)<>"~C"),IF(LEFT(B68,8)=LEFT(B69,8),B68,""),IF(LEFT(B68,8)=LEFT(B69,8),J68,""))))' selected>J69<OPTION value='=IF(AND(LEFT(C69,2)="~P",LEFT(B69,8)=LEFT(B70,8),LEN(W69)>0),IF(LEFT(C69,2)="~P","Parent Error",""),"")'>K69<OPTION value='=IF(AND(LEFT(C69,2)="~C",J69=""),"Missing Parent","")'>L69<OPTION value='=IF(C69="","",IF(LEFT(C70,2)="~P","",IF(AND(J69="",LEFT(C69,2)<>"~C"),IF(LEFT(B69,8)=LEFT(B70,8),B69,""),IF(LEFT(B69,8)=LEFT(B70,8),J69,""))))'>J70<OPTION value='=IF(AND(LEFT(C70,2)="~P",LEFT(B70,8)=LEFT(B71,8),LEN(W70)>0),IF(LEFT(C70,2)="~P","Parent Error",""),"")'>K70<OPTION value='=IF(AND(LEFT(C70,2)="~C",J70=""),"Missing Parent","")'>L70<OPTION value='=IF(C70="","",IF(LEFT(C71,2)="~P","",IF(AND(J70="",LEFT(C70,2)<>"~C"),IF(LEFT(B70,8)=LEFT(B71,8),B70,""),IF(LEFT(B70,8)=LEFT(B71,8),J70,""))))'>J71<OPTION value='=IF(AND(LEFT(C71,2)="~P",LEFT(B71,8)=LEFT(B72,8),LEN(W71)>0),IF(LEFT(C71,2)="~P","Parent Error",""),"")'>K71<OPTION value='=IF(AND(LEFT(C71,2)="~C",J71=""),"Missing Parent","")'>L71<OPTION value='=IF(C71="","",IF(LEFT(C72,2)="~P","",IF(AND(J71="",LEFT(C71,2)<>"~C"),IF(LEFT(B71,8)=LEFT(B72,8),B71,""),IF(LEFT(B71,8)=LEFT(B72,8),J71,""))))'>J72<OPTION value='=IF(AND(LEFT(C72,2)="~P",LEFT(B72,8)=LEFT(B73,8),LEN(W72)>0),IF(LEFT(C72,2)="~P","Parent Error",""),"")'>K72<OPTION value='=IF(AND(LEFT(C72,2)="~C",J72=""),"Missing Parent","")'>L72<OPTION value='=IF(C72="","",IF(LEFT(C73,2)="~P","",IF(AND(J72="",LEFT(C72,2)<>"~C"),IF(LEFT(B72,8)=LEFT(B73,8),B72,""),IF(LEFT(B72,8)=LEFT(B73,8),J72,""))))'>J73<OPTION value='=IF(AND(LEFT(C73,2)="~P",LEFT(B73,8)=LEFT(B74,8),LEN(W73)>0),IF(LEFT(C73,2)="~P","Parent Error",""),"")'>K73<OPTION value='=IF(AND(LEFT(C73,2)="~C",J73=""),"Missing Parent","")'>L73<OPTION value='=IF(C73="","",IF(LEFT(C74,2)="~P","",IF(AND(J73="",LEFT(C73,2)<>"~C"),IF(LEFT(B73,8)=LEFT(B74,8),B73,""),IF(LEFT(B73,8)=LEFT(B74,8),J73,""))))'>J74<OPTION value='=IF(AND(LEFT(C74,2)="~P",LEFT(B74,8)=LEFT(B75,8),LEN(W74)>0),IF(LEFT(C74,2)="~P","Parent Error",""),"")'>K74<OPTION value='=IF(AND(LEFT(C74,2)="~C",J74=""),"Missing Parent","")'>L74<OPTION value='=IF(C74="","",IF(LEFT(C75,2)="~P","",IF(AND(J74="",LEFT(C74,2)<>"~C"),IF(LEFT(B74,8)=LEFT(B75,8),B74,""),IF(LEFT(B74,8)=LEFT(B75,8),J74,""))))'>J75<OPTION value='=IF(AND(LEFT(C75,2)="~P",LEFT(B75,8)=LEFT(B76,8),LEN(W75)>0),IF(LEFT(C75,2)="~P","Parent Error",""),"")'>K75<OPTION value='=IF(AND(LEFT(C75,2)="~C",J75=""),"Missing Parent","")'>L75<OPTION value='=IF(C75="","",IF(LEFT(C76,2)="~P","",IF(AND(J75="",LEFT(C75,2)<>"~C"),IF(LEFT(B75,8)=LEFT(B76,8),B75,""),IF(LEFT(B75,8)=LEFT(B76,8),J75,""))))'>J76<OPTION value='=IF(AND(LEFT(C76,2)="~P",LEFT(B76,8)=LEFT(B77,8),LEN(W76)>0),IF(LEFT(C76,2)="~P","Parent Error",""),"")'>K76<OPTION value='=IF(AND(LEFT(C76,2)="~C",J76=""),"Missing Parent","")'>L76<OPTION value='=IF(C76="","",IF(LEFT(C77,2)="~P","",IF(AND(J76="",LEFT(C76,2)<>"~C"),IF(LEFT(B76,8)=LEFT(B77,8),B76,""),IF(LEFT(B76,8)=LEFT(B77,8),J76,""))))'>J77<OPTION value='=IF(AND(LEFT(C77,2)="~P",LEFT(B77,8)=LEFT(B78,8),LEN(W77)>0),IF(LEFT(C77,2)="~P","Parent Error",""),"")'>K77<OPTION value='=IF(AND(LEFT(C77,2)="~C",J77=""),"Missing Parent","")'>L77<OPTION value='=IF(C77="","",IF(LEFT(C78,2)="~P","",IF(AND(J77="",LEFT(C77,2)<>"~C"),IF(LEFT(B77,8)=LEFT(B78,8),B77,""),IF(LEFT(B77,8)=LEFT(B78,8),J77,""))))'>J78<OPTION value='=IF(AND(LEFT(C78,2)="~P",LEFT(B78,8)=LEFT(B79,8),LEN(W78)>0),IF(LEFT(C78,2)="~P","Parent Error",""),"")'>K78<OPTION value='=IF(AND(LEFT(C78,2)="~C",J78=""),"Missing Parent","")'>L78<OPTION value='=IF(C78="","",IF(LEFT(C79,2)="~P","",IF(AND(J78="",LEFT(C78,2)<>"~C"),IF(LEFT(B78,8)=LEFT(B79,8),B78,""),IF(LEFT(B78,8)=LEFT(B79,8),J78,""))))'>J79<OPTION value='=IF(AND(LEFT(C79,2)="~P",LEFT(B79,8)=LEFT(B80,8),LEN(W79)>0),IF(LEFT(C79,2)="~P","Parent Error",""),"")'>K79<OPTION value='=IF(AND(LEFT(C79,2)="~C",J79=""),"Missing Parent","")'>L79<OPTION value='=IF(C79="","",IF(LEFT(C80,2)="~P","",IF(AND(J79="",LEFT(C79,2)<>"~C"),IF(LEFT(B79,8)=LEFT(B80,8),B79,""),IF(LEFT(B79,8)=LEFT(B80,8),J79,""))))'>J80<OPTION value='=IF(AND(LEFT(C80,2)="~P",LEFT(B80,8)=LEFT(B81,8),LEN(W80)>0),IF(LEFT(C80,2)="~P","Parent Error",""),"")'>K80<OPTION value='=IF(AND(LEFT(C80,2)="~C",J80=""),"Missing Parent","")'>L80<OPTION value='=IF(C80="","",IF(LEFT(C81,2)="~P","",IF(AND(J80="",LEFT(C80,2)<>"~C"),IF(LEFT(B80,8)=LEFT(B81,8),B80,""),IF(LEFT(B80,8)=LEFT(B81,8),J80,""))))'>J81<OPTION value='=IF(AND(LEFT(C81,2)="~P",LEFT(B81,8)=LEFT(B82,8),LEN(W81)>0),IF(LEFT(C81,2)="~P","Parent Error",""),"")'>K81<OPTION value='=IF(AND(LEFT(C81,2)="~C",J81=""),"Missing Parent","")'>L81<OPTION value='=IF(C81="","",IF(LEFT(C82,2)="~P","",IF(AND(J81="",LEFT(C81,2)<>"~C"),IF(LEFT(B81,8)=LEFT(B82,8),B81,""),IF(LEFT(B81,8)=LEFT(B82,8),J81,""))))'>J82<OPTION value='=IF(AND(LEFT(C82,2)="~P",LEFT(B82,8)=LEFT(B83,8),LEN(W82)>0),IF(LEFT(C82,2)="~P","Parent Error",""),"")'>K82<OPTION value='=IF(AND(LEFT(C82,2)="~C",J82=""),"Missing Parent","")'>L82</OPTION></SELECT></TD><TD align=right width="3%" bgColor=#d4d0c8>=</TD><TD align=left bgColor=white><INPUT size=80 value='=IF(C68="","",IF(LEFT(C69,2)="~P","",IF(AND(J68="",LEFT(C68,2)<>"~C"),IF(LEFT(B68,8)=LEFT(B69,8),B68,""),IF(LEFT(B68,8)=LEFT(B69,8),J68,""))))' name=txbFb428726></TD></FORM></TR></TBODY></TABLE></TD></TR><TR><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; BORDER-LEFT: #000000 0.5pt solid; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>D</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>E</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>F</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>G</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>H</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>I</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>J</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>K</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>L</CENTER></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle><CENTER>M</CENTER></TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>69</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">686 05 Girls Donna Down Jacket Cloud M</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">SNOW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">JKTW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">239.99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">68645WDDJC</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[1].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[2].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">M</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>70</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">686 05 Girls Donna Down Jacket Cloud Xs</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">1</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">SNOW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">JKTW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">239.99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">68645WDDJC</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[4].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[5].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Xs</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>71</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">686 Girls Smarty Pant Gunmetal</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">999</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">SNOW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">PANTW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">199.99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[6].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[7].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[8].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>72</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">686 Girls Smarty Pant Gunmetal Sm</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">SNOW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">PANTW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">199.99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">68645WSCPG</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[10].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[11].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Sm</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>73</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">686 Girls Smarty Pant Gunmetal Xs</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">0</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">SNOW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">PANTW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">199.99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">68645WSCPG</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[13].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[14].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Xs</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>74</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">686 05 Girls Smarty Remote Jacket Grey</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">999</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">SNOW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">JKTW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">264.99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[15].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[16].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[17].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>75</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">686 05 Girls Smarty Remote Jacket Grey Xxs</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">2</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">SNOW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">JKTW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">264.99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">68645WSRG</FONT></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[19].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[20].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center">Xxs</TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>76</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">686 Ace Deploy Jacket Down Snowboard Brown</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">1998</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">SNOW</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">JKT</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">279.99</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right"> </TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[21].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[22].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left"><A onclick="document.formFb431795.sltNb305190.options[23].selected=true; document.formFb431795.txbFb428726.value = document.formFb431795.sltNb305190.value;" href="#javascript:void(0);"> </FONT></A></TD><TD style="BORDER-RIGHT: #000000 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"> </TD></TR><TR><TD style="BORDER-TOP: #000000 0.5pt solid; FONT-SIZE: 10pt; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; FONT-FAMILY: menu; BACKGROUND-COLOR: #d4d0c8" align=middle width="2%"><CENTER>77</CENTER></TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; BORDER-LEFT: #000000 0.5pt solid; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">686 Ace Deploy Jacket Down Snowboard Brown Lg</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: right">1</TD><TD style="BORDER-RIGHT: #d4d0c8 0.5pt solid; FONT-SIZE: 10pt; VERTICAL-ALIGN: bottom; COLOR: #000000; BORDER-BOTTOM: #d4d0c8 0.5pt solid; FONT-FAMILY: Arial; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: left">SNOW</TD><TD

 

[jindon]

Doug,

Sorry, but I can not find any relation to your sheet with the function posted.

Teh function
1) slipt the text in the cell by "sapce"
2) compare if the last element includes "#" or "-", and if there is Exit
3) if the last element is Numeric....

then if not, the function goes to find the last element if the named range "Size".

I don't think this is the right way, because even if the function is working OK, it will not respond any changes made to "Size".

Again, I can not find the relation with this function to the tables above.

 

[DougStroud]

Hi Jindon,
I am not sure if what I will write here will help explain it any further, but will try. You seem to have an accurate understanding of the function. So it may be that I fail to understand, but I will try to add a few more details here to help clear up for either one of us.
If I add a value to the table in the left column, which is actually a named range- "Sizes" and "Sizes" is actually a List, this value becomes a valid term the function will validate and keep in my second table in Col. M
If the last term in any cell in Col. D is anything other than numeric or a valid term, it does not place the value in Col. M.
For example, D71 has a last value of "Gunmetal", it does not meet the function's criteria and so M71 is left blank. (This I believe you already know, but just for assuredness sake).
But what I want the function to do is if it finds a valid value and is non-numeric, I want it to compare the values in "Sizes" List and swap out the value- So "S" which is a valid size in "Sizes" would be swapped w/ "Sm", "Large" would become "Lg", etc... Again- I think you understand this-
So if I do make a change to the named range "Sizes" and add a value it will add another valid value, just not look up, compare and swap.

If the function will not handle the additional function by the design of the function and cannot be edited to perform what I require or it can not handle it by the nature of what function are capable, I will add a vlookup or Find/Replace.

Thanks for assisting- sorry I had a long day and fell asleep at the keyboard--

Cheers,

Doug