Hi,
I'm in need of some help that is beyond my excel skill base at this point.
Below you'll see I have two sections, which represent two worksheets.
What I need is a formula that will in section 1, under the IDENTIFIER Column pull from all of column A (Transaction detail) all IDENTIFIERS (Highlighted in RED) in column A.
Once Column B is populated I need a formula that can pull from my second worksheet (SECTION 2: REFERENCE CHEAT SHEET) and based off column B's key identifier populate the location code.
Please help, any questions, or clarifications needed. Let me know.
SECTION 1:
[TABLE="width: 785"]
<tbody>[TR]
[TD]TRANSACTION DETAIL[/TD]
[TD]IDENTIFIER[/TD]
[TD]LOC. ID[/TD]
[/TR]
[TR]
[TD]AMER DENTAL PART CORP COLL ASSOCIATED DENTAL CARE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BOFA MERCH SVCS INTERCHNG 170102 345173192880 ADCP - CARONDELET[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BOFA MERCH SVCS INTERCHNG 170102 345173191882 ADCP - CAMPBELL[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BOFA MERCH SVCS INTERCHNG 170102 345173190884 ADCP- BELL
[TABLE="width: 535"]
<tbody>[TR]
[TD]AMERICAN EXPRESS SETTLEMENT 170102 5026725531 ASSOCIATED D5026725531[/TD]
[/TR]
[TR]
[TD]AMERICAN EXPRESS SETTLEMENT 170102 5026725580 ADCP CHANDLE5026725580[/TD]
[/TR]
[TR]
[TD]AMERICAN EXPRESS SETTLEMENT 161231 5026725572 ADCP SUN CIT5026725572[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 535"]
<tbody>[TR]
[TD]SYNCHRONY BANK BTOT DEP 170101 534812028488872 ASSOCIATED DENTAL CARE[/TD]
[/TR]
[TR]
[TD]SYNCHRONY BANK BTOT DEP 170101 534812028489345 ASSOCIATED DENTAL CARE[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 535"]
<tbody>[TR]
[TD]DEPOSIT #37[/TD]
[/TR]
[TR]
[TD]DEPOSIT #35[/TD]
[/TR]
[TR]
[TD]DEPOSIT #44
SECTION 2:
[TABLE="width: 615"]
<tbody>[TR]
[TD="colspan: 3"]REFERENCE CHEAT SHEET [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CC. Loc. Ref[/TD]
[TD]Loc.[/TD]
[TD]Type[/TD]
[TD][/TD]
[TD][/TD]
[TD]Deposit Loc. Ref[/TD]
[TD]Loc.[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]04586[/TD]
[TD]11[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #11[/TD]
[TD]CA[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]04594[/TD]
[TD]13[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #13[/TD]
[TD]MI[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]04610[/TD]
[TD]17[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #17[/TD]
[TD]AH[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]04628[/TD]
[TD]18[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #18[/TD]
[TD]SH[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]04693[/TD]
[TD]37[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #35[/TD]
[TD]CH[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]15951[/TD]
[TD]44[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #37[/TD]
[TD]SC[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]20328[/TD]
[TD]40[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #39[/TD]
[TD]CP[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]25499[/TD]
[TD]44[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #40[/TD]
[TD]IN[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]25507[/TD]
[TD]39[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #43[/TD]
[TD]BE[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]25515[/TD]
[TD]11[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #44[/TD]
[TD]QC[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]25531[/TD]
[TD]44[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25549[/TD]
[TD]40[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25556[/TD]
[TD]13[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]Care Credit[/TD]
[TD]Loc.[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]25564[/TD]
[TD]18[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]25572[/TD]
[TD]37[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488879[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]25580[/TD]
[TD]35[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488879[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]40884[/TD]
[TD]35[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]41882[/TD]
[TD]44[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028489345[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]42880[/TD]
[TD]43[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488877[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]71485[/TD]
[TD]43[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]72677[/TD]
[TD]35[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488879[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]85362[/TD]
[TD]39[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]90884[/TD]
[TD]43[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488880[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]91882[/TD]
[TD]39[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]92880[/TD]
[TD]11[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488873[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]95883[/TD]
[TD]17[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488880[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]96881[/TD]
[TD]40[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488874[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]97889[/TD]
[TD]13[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488877[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]98887[/TD]
[TD]18[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]99885[/TD]
[TD]37[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028489345[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488877[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488879[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488880[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]Ortho Loc. Ref[/TD]
[TD]Loc[/TD]
[TD]Name[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488874[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]CB[/TD]
[TD]39[/TD]
[TD]CP[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]SH[/TD]
[TD]18[/TD]
[TD]SH[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028489345[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]BR[/TD]
[TD]43[/TD]
[TD]BE[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488879[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I'm in need of some help that is beyond my excel skill base at this point.
Below you'll see I have two sections, which represent two worksheets.
What I need is a formula that will in section 1, under the IDENTIFIER Column pull from all of column A (Transaction detail) all IDENTIFIERS (Highlighted in RED) in column A.
Once Column B is populated I need a formula that can pull from my second worksheet (SECTION 2: REFERENCE CHEAT SHEET) and based off column B's key identifier populate the location code.
Please help, any questions, or clarifications needed. Let me know.
SECTION 1:
[TABLE="width: 785"]
<tbody>[TR]
[TD]TRANSACTION DETAIL[/TD]
[TD]IDENTIFIER[/TD]
[TD]LOC. ID[/TD]
[/TR]
[TR]
[TD]AMER DENTAL PART CORP COLL ASSOCIATED DENTAL CARE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BOFA MERCH SVCS INTERCHNG 170102 345173192880 ADCP - CARONDELET[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BOFA MERCH SVCS INTERCHNG 170102 345173191882 ADCP - CAMPBELL[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]BOFA MERCH SVCS INTERCHNG 170102 345173190884 ADCP- BELL
[TABLE="width: 535"]
<tbody>[TR]
[TD]AMERICAN EXPRESS SETTLEMENT 170102 5026725531 ASSOCIATED D5026725531[/TD]
[/TR]
[TR]
[TD]AMERICAN EXPRESS SETTLEMENT 170102 5026725580 ADCP CHANDLE5026725580[/TD]
[/TR]
[TR]
[TD]AMERICAN EXPRESS SETTLEMENT 161231 5026725572 ADCP SUN CIT5026725572[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 535"]
<tbody>[TR]
[TD]SYNCHRONY BANK BTOT DEP 170101 534812028488872 ASSOCIATED DENTAL CARE[/TD]
[/TR]
[TR]
[TD]SYNCHRONY BANK BTOT DEP 170101 534812028489345 ASSOCIATED DENTAL CARE[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 535"]
<tbody>[TR]
[TD]DEPOSIT #37[/TD]
[/TR]
[TR]
[TD]DEPOSIT #35[/TD]
[/TR]
[TR]
[TD]DEPOSIT #44
SECTION 2:
[TABLE="width: 615"]
<tbody>[TR]
[TD="colspan: 3"]REFERENCE CHEAT SHEET [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]CC. Loc. Ref[/TD]
[TD]Loc.[/TD]
[TD]Type[/TD]
[TD][/TD]
[TD][/TD]
[TD]Deposit Loc. Ref[/TD]
[TD]Loc.[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]04586[/TD]
[TD]11[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #11[/TD]
[TD]CA[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]04594[/TD]
[TD]13[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #13[/TD]
[TD]MI[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]04610[/TD]
[TD]17[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #17[/TD]
[TD]AH[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]04628[/TD]
[TD]18[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #18[/TD]
[TD]SH[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]04693[/TD]
[TD]37[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #35[/TD]
[TD]CH[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]15951[/TD]
[TD]44[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #37[/TD]
[TD]SC[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]20328[/TD]
[TD]40[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #39[/TD]
[TD]CP[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]25499[/TD]
[TD]44[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #40[/TD]
[TD]IN[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]25507[/TD]
[TD]39[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #43[/TD]
[TD]BE[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]25515[/TD]
[TD]11[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]DEPOSIT #44[/TD]
[TD]QC[/TD]
[TD]Cash/Chk[/TD]
[/TR]
[TR]
[TD]25531[/TD]
[TD]44[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25549[/TD]
[TD]40[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]25556[/TD]
[TD]13[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]Care Credit[/TD]
[TD]Loc.[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]25564[/TD]
[TD]18[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]25572[/TD]
[TD]37[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488879[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]25580[/TD]
[TD]35[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488879[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]40884[/TD]
[TD]35[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]41882[/TD]
[TD]44[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028489345[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]42880[/TD]
[TD]43[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488877[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]71485[/TD]
[TD]43[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]72677[/TD]
[TD]35[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488879[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]85362[/TD]
[TD]39[/TD]
[TD]AMEX[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]90884[/TD]
[TD]43[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488880[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]91882[/TD]
[TD]39[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]92880[/TD]
[TD]11[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488873[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]95883[/TD]
[TD]17[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488880[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]96881[/TD]
[TD]40[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488874[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]97889[/TD]
[TD]13[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488877[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]98887[/TD]
[TD]18[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]99885[/TD]
[TD]37[/TD]
[TD]MC/Visa[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028489345[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488877[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488879[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488880[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]Ortho Loc. Ref[/TD]
[TD]Loc[/TD]
[TD]Name[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488874[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]CB[/TD]
[TD]39[/TD]
[TD]CP[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488872[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]SH[/TD]
[TD]18[/TD]
[TD]SH[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028489345[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
[TR]
[TD]BR[/TD]
[TD]43[/TD]
[TD]BE[/TD]
[TD][/TD]
[TD][/TD]
[TD]534812028488879[/TD]
[TD][/TD]
[TD]EFT[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]