Column Compare

rabalam

New Member
Joined
Aug 9, 2010
Messages
9
So I will try and explain to my best ability as to what I am trying to acomplish.

U have two sepreate spreadsheet for name sake we'll call them SheetA and SheetB.

I have information in Column a, b, C, and D in sheetA
I have information in Column a, B, c in sheetB

The format of information on sheetA column A 1901234 unsorted

The format of the information on sheet be column A abcdefg1901234 unsorted

I am tryin to compare the two documents and the columns and actully try and match them up so that they can appear in one document side by side.

I am curently going line by line from sheet A doing a search and find and the equivalent last 7 digits and adding the information maually. Well I have over 500 devices I have to this for. I knwo there got to be a short cut. Any help would be greatly appreciated.

Thanks,
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
If you're always looking to match the last x numbers in your second column, you can use the right formula in column C. This takes the length of column A, and pulls that number of digits from B1.

=RIGHT(B1, LEN(A1))

Then you can create a VLOOKUP and just use that to find matches.

HTH,
Roger
 
Upvote 0
First the Assumptions:
1. Sheet from which the data will be extracted is named "SheetB"
2. SheetB contains the data in column A and upto row 500.
3. SheetA needs to be populated, column A already contains values and column B will be populated based on these values.

On SheetA, enter the following array formula:

=INDEX(SheetB!$A$1:$A$500,MATCH(VLOOKUP(A1,(RIGHT(SheetB!$A$1:$A$500,7)*1),1,FALSE),(RIGHT(SheetB!$A$1:$A$500,7)*1),0),1)

Make sure that after entering this formula,you do not hit just enter but Ctrl+Shift+Enter together since this is an array formula.

Cheers,
tc
 
Upvote 0
Also, if you only want to return the corresponding values then the formula would be:

=VLOOKUP(A3,(RIGHT(SheetB!$A$2:$C$27,7)*1),2,0)

Kindly note, as per my previous post, that this too is an array formula and therefore enter the formula with Ctrl+Shift+Enter

tc
 
Upvote 0
If you had the values:
Excel Workbook
A
11901234
21010109
31587336
SheetA


and the values:
Excel Workbook
A
1dssddsd1010109
2ssqewq1587336
3abcdefg1901234
SheetB


and you wanted to take the items on SheetA as the lookup values that would allow you to find a value from SheetB and return them to SheetA, maybe this will work:
Excel Workbook
AB
11901234abcdefg1901234
21010109dssddsd1010109
31587336ssqewq1587336
SheetA
#VALUE!
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.

That is, put this formula in cell B1 with the keystrokes Ctrl + Shift + Enter, then copy down:

=INDEX(SheetB!$A$1:$A$3,MATCH(A1&"",RIGHT(SheetB!$A$1:$A$3,7),0))
 
Last edited:
Upvote 0
Thanks for the help but as I am not a excel guru I need a little more help.

****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 12">****** name="Originator" content="Microsoft Word 12"><link rel="File-List" href="file:///C:%5CUsers%5Crabalam%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_filelist.xml"><link rel="Preview" href="file:///C:%5CUsers%5Crabalam%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_preview.wmf"><!--[if gte mso 9]><xml> <o:DocumentProperties> <o:Version>12.00</o:Version> </o:DocumentProperties> </xml><![endif]--><link rel="themeData" href="file:///C:%5CUsers%5Crabalam%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_themedata.thmx"><link rel="colorSchemeMapping" href="file:///C:%5CUsers%5Crabalam%5CAppData%5CLocal%5CTemp%5Cmsohtmlclip1%5C01%5Cclip_colorschememapping.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:TrackMoves/> <w:TrackFormatting/> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:DoNotPromoteQF/> <w:LidThemeOther>EN-US</w:LidThemeOther> <w:LidThemeAsian>X-NONE</w:LidThemeAsian> <w:LidThemeComplexScript>X-NONE</w:LidThemeComplexScript> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> <w:SplitPgBreakAndParaMark/> <w:DontVertAlignCellWithSp/> <w:DontBreakConstrainedForcedTables/> <w:DontVertAlignInTxbx/> <w:Word11KerningPairs/> <w:CachedColBalance/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> <m:mathPr> <m:mathFont m:val="Cambria Math"/> <m:brkBin m:val="before"/> <m:brkBinSub m:val="--"/> <m:smallFrac m:val="off"/> <m:dispDef/> <m:lMargin m:val="0"/> <m:rMargin m:val="0"/> <m:defJc m:val="centerGroup"/> <m:wrapIndent m:val="1440"/> <m:intLim m:val="subSup"/> <m:naryLim m:val="undOvr"/> </m:mathPr></w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" DefUnhideWhenUsed="true" DefSemiHidden="true" DefQFormat="false" DefPriority="99" LatentStyleCount="267"> <w:LsdException Locked="false" Priority="0" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Normal"/> <w:LsdException Locked="false" Priority="9" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="heading 1"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 2"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 3"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 4"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 5"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 6"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 7"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 8"/> <w:LsdException Locked="false" Priority="9" QFormat="true" Name="heading 9"/> <w:LsdException Locked="false" Priority="39" Name="toc 1"/> <w:LsdException Locked="false" Priority="39" Name="toc 2"/> <w:LsdException Locked="false" Priority="39" Name="toc 3"/> <w:LsdException Locked="false" Priority="39" Name="toc 4"/> <w:LsdException Locked="false" Priority="39" Name="toc 5"/> <w:LsdException Locked="false" Priority="39" Name="toc 6"/> <w:LsdException Locked="false" Priority="39" Name="toc 7"/> <w:LsdException Locked="false" Priority="39" Name="toc 8"/> <w:LsdException Locked="false" Priority="39" Name="toc 9"/> <w:LsdException Locked="false" Priority="35" QFormat="true" Name="caption"/> <w:LsdException Locked="false" Priority="10" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Title"/> <w:LsdException Locked="false" Priority="1" Name="Default Paragraph Font"/> <w:LsdException Locked="false" Priority="11" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtitle"/> <w:LsdException Locked="false" Priority="22" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Strong"/> <w:LsdException Locked="false" Priority="20" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Emphasis"/> <w:LsdException Locked="false" Priority="59" SemiHidden="false" UnhideWhenUsed="false" Name="Table Grid"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Placeholder Text"/> <w:LsdException Locked="false" Priority="1" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="No Spacing"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 1"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 1"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 1"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 1"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 1"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 1"/> <w:LsdException Locked="false" UnhideWhenUsed="false" Name="Revision"/> <w:LsdException Locked="false" Priority="34" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="List Paragraph"/> <w:LsdException Locked="false" Priority="29" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Quote"/> <w:LsdException Locked="false" Priority="30" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Quote"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 1"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 1"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 1"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 1"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 1"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 1"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 1"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 1"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 2"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 2"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 2"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 2"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 2"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 2"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 2"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 2"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 2"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 2"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 2"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 2"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 2"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 2"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 3"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 3"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 3"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 3"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 3"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 3"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 3"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 3"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 3"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 3"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 3"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 3"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 3"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 3"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 4"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 4"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 4"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 4"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 4"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 4"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 4"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 4"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 4"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 4"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 4"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 4"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 4"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 4"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 5"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 5"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 5"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 5"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 5"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 5"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 5"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 5"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 5"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 5"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 5"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 5"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 5"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 5"/> <w:LsdException Locked="false" Priority="60" SemiHidden="false" UnhideWhenUsed="false" Name="Light Shading Accent 6"/> <w:LsdException Locked="false" Priority="61" SemiHidden="false" UnhideWhenUsed="false" Name="Light List Accent 6"/> <w:LsdException Locked="false" Priority="62" SemiHidden="false" UnhideWhenUsed="false" Name="Light Grid Accent 6"/> <w:LsdException Locked="false" Priority="63" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 1 Accent 6"/> <w:LsdException Locked="false" Priority="64" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Shading 2 Accent 6"/> <w:LsdException Locked="false" Priority="65" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 1 Accent 6"/> <w:LsdException Locked="false" Priority="66" SemiHidden="false" UnhideWhenUsed="false" Name="Medium List 2 Accent 6"/> <w:LsdException Locked="false" Priority="67" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 1 Accent 6"/> <w:LsdException Locked="false" Priority="68" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 2 Accent 6"/> <w:LsdException Locked="false" Priority="69" SemiHidden="false" UnhideWhenUsed="false" Name="Medium Grid 3 Accent 6"/> <w:LsdException Locked="false" Priority="70" SemiHidden="false" UnhideWhenUsed="false" Name="Dark List Accent 6"/> <w:LsdException Locked="false" Priority="71" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Shading Accent 6"/> <w:LsdException Locked="false" Priority="72" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful List Accent 6"/> <w:LsdException Locked="false" Priority="73" SemiHidden="false" UnhideWhenUsed="false" Name="Colorful Grid Accent 6"/> <w:LsdException Locked="false" Priority="19" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Emphasis"/> <w:LsdException Locked="false" Priority="21" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Emphasis"/> <w:LsdException Locked="false" Priority="31" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Subtle Reference"/> <w:LsdException Locked="false" Priority="32" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Intense Reference"/> <w:LsdException Locked="false" Priority="33" SemiHidden="false" UnhideWhenUsed="false" QFormat="true" Name="Book Title"/> <w:LsdException Locked="false" Priority="37" Name="Bibliography"/> <w:LsdException Locked="false" Priority="39" QFormat="true" Name="TOC Heading"/> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Font Definitions */ @font-face {font-family:"Cambria Math"; panose-1:2 4 5 3 5 4 6 3 2 4; mso-font-charset:0; mso-generic-font-family:roman; mso-font-pitch:variable; mso-font-signature:-536870145 1107305727 0 0 415 0;} @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-520092929 1073786111 9 0 415 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-unhide:no; mso-style-qformat:yes; mso-style-parent:""; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; mso-add-space:auto; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraphCxSpFirst, li.MsoListParagraphCxSpFirst, div.MsoListParagraphCxSpFirst {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0in; margin-right:0in; margin-bottom:0in; margin-left:.5in; margin-bottom:.0001pt; mso-add-space:auto; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraphCxSpMiddle, li.MsoListParagraphCxSpMiddle, div.MsoListParagraphCxSpMiddle {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0in; margin-right:0in; margin-bottom:0in; margin-left:.5in; margin-bottom:.0001pt; mso-add-space:auto; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} p.MsoListParagraphCxSpLast, li.MsoListParagraphCxSpLast, div.MsoListParagraphCxSpLast {mso-style-priority:34; mso-style-unhide:no; mso-style-qformat:yes; mso-style-type:export-only; margin-top:0in; margin-right:0in; margin-bottom:10.0pt; margin-left:.5in; mso-add-space:auto; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoChpDefault {mso-style-type:export-only; mso-default-props:yes; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-fareast-font-family:Calibri; mso-fareast-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} .MsoPapDefault {mso-style-type:export-only; margin-bottom:10.0pt; line-height:115%;} @page WordSection1 {size:8.5in 11.0in; margin:1.0in 1.0in 1.0in 1.0in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.WordSection1 {page:WordSection1;} /* List Definitions */ @list l0 {mso-list-id:478117107; mso-list-type:hybrid; mso-list-template-ids:207919820 67698703 67698713 67698715 67698703 67698713 67698715 67698703 67698713 67698715;} @list l0:level1 {mso-level-tab-stop:none; mso-level-number-position:left; text-indent:-.25in;} ol {margin-bottom:0in;} ul {margin-bottom:0in;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-priority:99; mso-style-qformat:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin-top:0in; mso-para-margin-right:0in; mso-para-margin-bottom:10.0pt; mso-para-margin-left:0in; line-height:115%; mso-pagination:widow-orphan; font-size:11.0pt; font-family:"Calibri","sans-serif"; mso-ascii-font-family:Calibri; mso-ascii-theme-font:minor-latin; mso-hansi-font-family:Calibri; mso-hansi-theme-font:minor-latin; mso-bidi-font-family:"Times New Roman"; mso-bidi-theme-font:minor-bidi;} </style> <![endif]--> Sheet A
<table class="MsoNormalTable" style="width: 518pt; margin-left: 4.4pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="691"> <tbody><tr style="height: 39.75pt;"> <td style="width: 74pt; border: 1pt solid windowtext; background: none repeat scroll 0% 0% rgb(149, 179, 215); padding: 0in 5.4pt; height: 39.75pt;" width="99">
[FONT=&quot]Room #[/FONT][FONT=&quot]<o:p></o:p>[/FONT]
</td> <td style="width: 83pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(149, 179, 215); padding: 0in 5.4pt; height: 39.75pt;" width="111">
[FONT=&quot]Cube #[/FONT][FONT=&quot]<o:p></o:p>[/FONT]
</td> <td style="width: 83pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(149, 179, 215); padding: 0in 5.4pt; height: 39.75pt;" width="111">
[FONT=&quot]Old jack #[/FONT][FONT=&quot]<o:p></o:p>[/FONT]
</td> <td style="width: 60pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(149, 179, 215); padding: 0in 5.4pt; height: 39.75pt;" width="80">
[FONT=&quot]X-con Y/N[/FONT][FONT=&quot]<o:p></o:p>[/FONT]
</td> <td style="width: 98pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(149, 179, 215); padding: 0in 5.4pt; height: 39.75pt;" width="131">
[FONT=&quot]Switch ID / port[/FONT][FONT=&quot]<o:p></o:p>[/FONT]
</td> <td style="width: 120pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(149, 179, 215); padding: 0in 5.4pt; height: 39.75pt;" width="160">
[FONT=&quot]Device ID (NWAM#)[/FONT][FONT=&quot]<o:p></o:p>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]415<o:p></o:p>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT=&quot] <o:p></o:p>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT=&quot]6235<o:p></o:p>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT=&quot]1905803<o:p></o:p>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]415<o:p></o:p>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT=&quot] <o:p></o:p>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT=&quot]6236<o:p></o:p>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]416<o:p></o:p>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT=&quot] <o:p></o:p>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT=&quot]6287<o:p></o:p>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT=&quot]1056562<o:p></o:p>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]417<o:p></o:p>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT=&quot] <o:p></o:p>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT=&quot]6288<o:p></o:p>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT=&quot]1056202<o:p></o:p>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]418<o:p></o:p>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT=&quot] <o:p></o:p>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT=&quot]6286<o:p></o:p>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT=&quot]1056349<o:p></o:p>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]420<o:p></o:p>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT=&quot] <o:p></o:p>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT=&quot]6289<o:p></o:p>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT=&quot]1056563<o:p></o:p>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]421<o:p></o:p>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111"> [FONT=&quot] <o:p></o:p>[/FONT]
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT=&quot]6290<o:p></o:p>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT=&quot]1093103<o:p></o:p>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]425<o:p></o:p>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT=&quot]1<o:p></o:p>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT=&quot]6246<o:p></o:p>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT=&quot]1092895<o:p></o:p>[/FONT]
</td> </tr> <tr style="height: 24.95pt;"> <td style="width: 74pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]425<o:p></o:p>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT=&quot]2<o:p></o:p>[/FONT]​
</td> <td style="width: 83pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT=&quot]6245<o:p></o:p>[/FONT]
</td> <td style="width: 60pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="80">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 98pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" nowrap="nowrap" valign="bottom" width="131">
[FONT=&quot] <o:p></o:p>[/FONT]

</td> <td style="width: 120pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(253, 233, 217); padding: 0in 5.4pt; height: 24.95pt;" valign="bottom" width="160">
[FONT=&quot]1905835[/FONT][FONT=&quot]<o:p></o:p>[/FONT]
</td> </tr> </tbody></table> <o:p> </o:p>
Sheet B
<table class="MsoNormalTable" style="width: 370.4pt; margin-left: 4.85pt; border-collapse: collapse; border: medium none;" border="1" cellpadding="0" cellspacing="0" width="494"> <tbody><tr style="height: 51.8pt;"> <td style="width: 74.25pt; border: 1pt solid windowtext; background: none repeat scroll 0% 0% rgb(255, 204, 153); padding: 0in 5.4pt; height: 51.8pt;" valign="bottom" width="99">
[FONT=&quot]Current NTWK Drop<o:p></o:p>[/FONT]
</td> <td style="width: 147.65pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(255, 204, 153); padding: 0in 5.4pt; height: 51.8pt;" valign="bottom" width="197">
[FONT=&quot]Current DNS Name<o:p></o:p>[/FONT]
</td> <td style="width: 74.25pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(255, 204, 153); padding: 0in 5.4pt; height: 51.8pt;" valign="bottom" width="99">
[FONT=&quot]Room #<o:p></o:p>[/FONT]
</td> <td style="width: 74.25pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; background: none repeat scroll 0% 0% rgb(255, 204, 153); padding: 0in 5.4pt; height: 51.8pt;" valign="bottom" width="99">
[FONT=&quot]Cube #<o:p></o:p>[/FONT]
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6126<o:p></o:p>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwks133.some.domain.com<o:p></o:p>​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]112<o:p></o:p>[/FONT]​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]4<o:p></o:p>[/FONT]​
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
lvkbarbercoleman.some.domain.com<o:p></o:p>​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvk01la-03.some.domain.com<o:p></o:p>​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6062<o:p></o:p>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
lvkmedrpt1.some.domain.com<o:p></o:p>​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]013<o:p></o:p>[/FONT]​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]2<o:p></o:p>[/FONT]​
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvk01la-04.some.domain.com<o:p></o:p>​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6177<o:p></o:p>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
lvkmedrpt2.some.domain.com<o:p></o:p>​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]013<o:p></o:p>[/FONT]​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]2<o:p></o:p>[/FONT]​
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6200<o:p></o:p>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam1817046.some.domain.com<o:p></o:p>​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]135a<o:p></o:p>[/FONT]​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]2<o:p></o:p>[/FONT]​
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6057<o:p></o:p>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam1847576.some.domain.com<o:p></o:p>​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]112<o:p></o:p>[/FONT]​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]3<o:p></o:p>[/FONT]​
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6036<o:p></o:p>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam1850699.some.domain.com<o:p></o:p>​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]108<o:p></o:p>[/FONT]​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]2<o:p></o:p>[/FONT]​
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6176<o:p></o:p>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam1901674.some.domain.com<o:p></o:p>​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]013<o:p></o:p>[/FONT]​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]2<o:p></o:p>[/FONT]​
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6031<o:p></o:p>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam1036158.some.domain.com<o:p></o:p>​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]012<o:p></o:p>[/FONT]​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]1<o:p></o:p>[/FONT]​
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
6198<o:p></o:p>
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam1905849.some.domain.com<o:p></o:p>​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]135<o:p></o:p>[/FONT]​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
[FONT=&quot]3<o:p></o:p>[/FONT]​
</td> </tr> <tr style="height: 13.65pt;"> <td style="width: 74.25pt; border-width: medium 1pt 1pt; border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 147.65pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="197">
nwlvkam1905835.some.domain.com<o:p></o:p>​
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> <td style="width: 74.25pt; border-width: medium 1pt 1pt medium; border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 13.65pt;" nowrap="nowrap" valign="bottom" width="99">
</td> </tr> </tbody></table> <o:p> </o:p>
The End result would then look like the below:
<table class="MsoNormalTable" style="width: 5.75in; margin-left: 4.4pt; border-collapse: collapse; border: medium none;" border="1" cellpadding="0" cellspacing="0" width="552"> <tbody><tr style="height: 15pt;"> <td style="width: 83pt; border: 1pt solid windowtext; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="111">
6245
<o:p></o:p>
</td> <td style="width: 165pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="220">
nwlvkam1905835.some.domain.com<o:p></o:p>​
</td> <td style="width: 83pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT=&quot]425<o:p></o:p>[/FONT]
</td> <td style="width: 83pt; border-width: 1pt 1pt 1pt medium; border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; padding: 0in 5.4pt; height: 15pt;" nowrap="nowrap" valign="bottom" width="111">
[FONT=&quot]2<o:p></o:p>[/FONT]
</td> </tr> </tbody></table> <o:p> </o:p>
Here is an example of my data that I have to work with. So from SheetA we have column “Devicename” in SheetB we have “Current DNS Name”.
<o:p> </o:p>
From SheetA you have columns “cube” and “old jack” both of these are important information that I would like to keep.
So I am trying to do a few things:
<!--[if !supportLists]-->1. <!--[endif]-->I am trying to compare and match SheetA “Devicename” column with SheetB “Current DNS Name” and finding matches for the numbers only and ignoring the text.
<!--[if !supportLists]-->2. <!--[endif]-->Once find the match fill out the corresponding cells.
So lets say we key on 1905835match on and I do a search in SheetB I would then manually fill in the “Current NTWK Drop” with the corresponding “Old Jack#” as well “Cube” and “Room”.
So I would like to bring both documents up I already have a macro that I can merge the two spreadsheets creating two separate workbooks so as to just work from one file. But the main goal is to automate that manual process I just described. I have over 500 device I have to line by doing a find and then manually entering the data in the appropriate columns.. as you can see this can lead to multiple input errors as well as time consuming?
I want this process to be a repeatable process because I have about 11 more sites that will go through this same rework each site having 500 or more devices each.
I hope this make it a bit clearer as to what I am trying to accomplish.
Thank you in advance for any assistance anyone can give.


R
 
Last edited:
Upvote 0
Perhaps this:
Excel Workbook
ABCDEF
1Room #Cube #Old jack #X-con Y/NSwitch ID / portDevice ID (NWAM#)
2425262451905835
34303621115874
SheetA



Green cells have formulas:
Excel Workbook
ABCD
1NTWK DropCurrent DNS NameRoom #Cube #
26245nwlvkam1905835.some.domain.com4252
36211ddsdsds15874.some.com4303
SheetB


Enter formula in cell A2 with Ctrl + Shift + Enter then copy down:

=INDEX(SheetA!$C$2:$C$3,MATCH(MID(B2,MATCH(TRUE,ISNUMBER(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)),0),COUNT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)))+0,SheetA!$F$2:$F$3,0))


Enter formula in cell C2 with Ctrl + Shift + Enter then copy down:

=INDEX(SheetA!$A$2:$A$3,MATCH(MID(B2,MATCH(TRUE,ISNUMBER(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)),0),COUNT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)))+0,SheetA!$F$2:$F$3,0))



Enter formula in cell D2 with Ctrl + Shift + Enter then copy down:

=INDEX(SheetA!$B$2:$B$3,MATCH(MID(B2,MATCH(TRUE,ISNUMBER(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)),0),COUNT(--MID(B2,ROW(INDIRECT("1:"&LEN(B2))),1)))+0,SheetA!$F$2:$F$3,0))

This assumes that there will only be one number in the text string like this:

ddsdsds15874.some.com

not like this:

ddsdsds15874.some.com434523

Maybe that will work?
 
Upvote 0
Hmm interesting .. every time I copy and paste the formula in teh appropriate cells I get the open file window pop up as to want me to open a file. I hit cancel and I get the #N/A in teh cell in which I pasted the formula.

and BTW way thank you fro taking the time to help me through this.

G
 
Upvote 0
It may be because you do not have a sheet named "SheetA". Try copying the small data set that I posted to a workbook and name the sheet "SheetA". Then copy the data from post for "SheetB", name a sheet "SheetB", then try the formulas. If they seem to work you can try to adapt them to your data sets.
 
Upvote 0
moz-screenshot.png
well creating the sheetA and B respectfully worked as far as not getting a popup window. I'm still getting the #N/A int cell where I pasted the formula. I did not try to enter the formula by hand I cut and pasted it directly from your post.

Did you test this and it worked? if so I'll tinker with it more to see if I'm missing something.

thx,

-r

moz-screenshot-2.png
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,256
Members
448,558
Latest member
aivin

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