Search text string and return a value from another cell

J

johnsos1

New Member
Joined
Jul 9, 2014
Messages
3
Hi,

I am struggling to find the right solution to a problem I have with my two spreadsheets. please can you help? Sorry about the formatting of the below tables.

Basically, I need to search the text string in sheet 2 C1, for the unique asset ID found also in sheet 1. But to then return the equipment number into cell D2 of sheet 2.

Please can you help with the formula for this? I don't even know where to start with the correct formula!

Many thanks,
Steve


Sheet 1
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD][TABLE="width: 77"]
<tbody>[TR]
[TD]A[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 145"]
<tbody>[TR]
[TD]B[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD]C[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD]D[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR]
[TD]Property ref[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 145"]
<tbody>[TR]
[TD]Property Name[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 287"]
<tbody>[TR]
[TD]Equipment number[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD]Unique Asset ID[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]6155[/TD]
[TD][TABLE="width: 145"]
<tbody>[TR]
[TD]SEVENOAKS 67 HIGH STREET - 6157[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 287"]
<tbody>[TR]
[TD]1229060[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD]ABC0003LAWH1[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR]
[TD]6177[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 145"]
<tbody>[TR]
[TD]HOVE 103 CHURCH ROAD - 6177[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 287"]
<tbody>[TR]
[TD]1228810[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD]ABC0003LYD1[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR]
[TD]6177[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 145"]
<tbody>[TR]
[TD]HOVE 103 CHURCH ROAD - 6177[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 287"]
<tbody>[TR]
[TD]1228811[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD]ABC0003LYD2[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]














Sheet 2

[TABLE="width: 500, align: left"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD][TABLE="width: 77"]
<tbody>[TR]
[TD]Property ref[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 145"]
<tbody>[TR]
[TD]Property Name[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 287"]
<tbody>[TR]
[TD]Description[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD]Equipment Number[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]6157[/TD]
[TD][TABLE="class: grid, width: 145, align: left"]
<tbody>[TR]
[TD]SEVENOAKS 67 HIGH STREET - 6157[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 287"]
<tbody>[TR]
[TD]B DEFECT (non com) Job for Lift Maintenance contractor - 3872 ABC0003LAWH1 - MIG-2024994 Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out Maintenance items in accordance with report [/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 159"]
<tbody>[TR]
[TD]"=???[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]6177[/TD]
[TD][TABLE="width: 145"]
<tbody>[TR]
[TD]HOVE 103 CHURCH ROAD - 6177[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 287"]
<tbody>[TR]
[TD]B DEFECT (non com) Job for Lift Maintenance contractor - 6766 ABC0003LYD1-LMN1 - MIG-2017502 - Electric Hydraulic Goods Lift - Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out Maintenance items in accordance with report 6766[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]6177[/TD]
[TD][TABLE="width: 145"]
<tbody>[TR]
[TD]HOVE 103 CHURCH ROAD - 6177[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][TABLE="width: 287"]
<tbody>[TR]
[TD]B DEFECT (non com) Job for Lift Maintenance contractor - 4017 ABC0003LYD2 - MIG-2065593 - Passenger/Goods Lift - Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out Maintenance items in accordance with report[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
 

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).
Sort by date Sort by votes
johnsos1,

Welcome to the MrExcel forum.

1. What version of Excel and Windows are you using?

2. Are you using a PC or a Mac?


Sample worksheets:


Excel 2007
ABCD
1Property refProperty NameEquipment numberUnique Asset ID
26155SEVENOAKS 67 HIGH STREET - 61571229060ABC0003LAWH1
36177HOVE 103 CHURCH ROAD - 61771228810ABC0003LYD1
46177HOVE 103 CHURCH ROAD - 61771228811ABC0003LYD2
5
Sheet1



Excel 2007
ABCD
1Property refProperty NameDescriptionEquipment Number
26157SEVENOAKS 67 HIGH STREET - 6157B DEFECT (non com) Job for Lift Maintenance contractor - 3872 ABC0003LAWH1 - MIG-2024994 Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out Maintenance items in accordance with report
36177HOVE 103 CHURCH ROAD - 6177B DEFECT (non com) Job for Lift Maintenance contractor - 6766 ABC0003LYD1-LMN1 - MIG-2017502 - Electric Hydraulic Goods Lift - Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out Maintenance items in accordance with report 6766
46177HOVE 103 CHURCH ROAD - 6177B DEFECT (non com) Job for Lift Maintenance contractor - 4017 ABC0003LYD2 - MIG-2065593 - Passenger/Goods Lift - Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out Maintenance items in accordance with report
5
Sheet2


After the macro in worksheet Sheet2:


Excel 2007
ABCD
1Property refProperty NameDescriptionEquipment Number
26157SEVENOAKS 67 HIGH STREET - 6157B DEFECT (non com) Job for Lift Maintenance contractor - 3872 ABC0003LAWH1 - MIG-2024994 Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out Maintenance items in accordance with report1229060
36177HOVE 103 CHURCH ROAD - 6177B DEFECT (non com) Job for Lift Maintenance contractor - 6766 ABC0003LYD1-LMN1 - MIG-2017502 - Electric Hydraulic Goods Lift - Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out Maintenance items in accordance with report 67661228810
46177HOVE 103 CHURCH ROAD - 6177B DEFECT (non com) Job for Lift Maintenance contractor - 4017 ABC0003LYD2 - MIG-2065593 - Passenger/Goods Lift - Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out Maintenance items in accordance with report1228811
5
Sheet2


Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the below code
2. Open your NEW workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. Press the keys ALT + I to activate the Insert menu
5. Press M to insert a Standard Module
6. Where the cursor is flashing, paste the code
7. Press the keys ALT + Q to exit the Editor, and return to Excel
8. To run the macro from Excel press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.

Code: 
Sub ReturnEquipmentNumber()
' hiker95, 07/09/2014, ME790500
Dim c As Range, uaid As Range, lr As Long, n As Long, i As Long, sr As Long
Application.ScreenUpdating = False
lr = Sheets("Sheet2").Cells(Rows.Count, 3).End(xlUp).Row
With Sheets("Sheet1")
  For Each c In .Range("D2", .Range("D" & Rows.Count).End(xlUp))
    sr = 1
    n = Application.CountIf(Sheets("Sheet2").Range("C" & sr & ":C" & lr), "*" & c & "*")
    For i = 1 To n Step 1
      Set uaid = Sheets("Sheet2").Range("C" & sr & ":C" & lr).Find("*" & c.Value & "*", LookAt:=xlWhole)
      If Not uaid Is Nothing Then
        Sheets("Sheet2").Range("D" & uaid.Row) = c.Offset(, -1).Value
        sr = uaid.Row
        Set uaid = Nothing
      End If
    Next i
  Next c
End With
Application.ScreenUpdating = True
End Sub

Before you use the macro with Excel 2007 or newer, save your workbook, Save As, a macro enabled workbook with the file extension .xlsm

Then run the ReturnEquipmentNumber macro.
 
Upvote 0
Hi Hiker95Many thanks for responding so quickly. Your reply is certainly juicy! I am running Windows 2007 Enterprise on a standard IBM workbook, with Office 2010. When originally posting I think I over simplified the worksheets, but also changed some of the data in the cells as the data cannot be made public, not thinking I needed to run a macro. Sorry for the confusion in advance, but it gave a flavour of what I needed. I've tried your script and I keep getting a runtime error "13" type mismatch.I tried to change the formulas to reflect the correct data I actually have in the sheets, but I get the same error code.To clarify what I am actually looking at, if this helps, is the following - and I hope I don't confuse anyone with this.In sheet2Equipment number is in column H - "1229027"Unique Asset ID is in column I - "RBSRBS0003LWA2"In sheet1Text string containing the UID on my working sheet is in column H - (Contains the above "RBS" code)Column which needs to be populated with the Equipment number is FAnd assuming we're working in cell 2.Hope this makes sense? Many thanks for your help.RegardsSteve
 
Upvote 0
johnsos1,

It is always best to display your actual raw data worksheet(s), and, the results that you are looking for. This way we can usually find a solution on the first go.

In order to continue, and, so that I can get it right this next time:


Can you post a screenshot of the actual raw data worksheet?

And, can you post a screenshot of worksheet results (manually formatted by you) with the results that you are looking for?

To post your data, you can download and install one of the following two programs:
Excel Jeanie
Download

MrExcel HTMLMaker20101230
https://onedrive.live.com/?cid=8cffdec0ce27e813&sc=documents&id=8CFFDEC0CE27E813!189

Installation instructions here:
http://www.mrexcel.com/forum/board-announcements/515787-forum-posting-guidelines.html#post2545970


If you are not able to give us screenshots:
You can upload your workbook to Box Net,
sensitive data changed
mark the workbook for sharing
and provide us with a link to your workbook.
 
Upvote 0
Hi

You probably think i am being a right pain, but I can't download anything onto my computer as it is locked down for protection. The data I am using is extremely sensitive due to it being linked with a major financial institution, so I hope you can bear with me and still continue to help. I will try again with another edited version of my spreadsheets, but this time much more reflective of the data I am actually using.

So here we have sheet 1. This is my "working" spreadsheet.

[TABLE="width: 2371"]
<tbody>[TR]
[TD]Property #[/TD]
[TD]Id[/TD]
[TD]Service Leader[/TD]
[TD]Service Engineer[/TD]
[TD]Region[/TD]
[TD]Equipment number[/TD]
[TD]PropName[/TD]
[TD]Description[/TD]
[TD]DateRequested[/TD]
[TD]TargetComplDate[/TD]
[TD]TargetCompMonth[/TD]
[TD]PriorityName[/TD]
[TD]PhysicalCompletionDate[/TD]
[TD]TaskGroupItem[/TD]
[TD]StatusName[/TD]
[TD]RBS Region Name[/TD]
[/TR]
[TR]
[TD]9402[/TD]
[TD]584807[/TD]
[TD]Mr Paulo Fernandes[/TD]
[TD]Gary Rand[/TD]
[TD]London[/TD]
[TD] [/TD]
[TD]LONDON HENDON 95 CHURCH ROAD - 9402[/TD]
[TD]B DEFECT (non com) Job for Lift Maintenance contractor - 9402 RBS0003-LKX1 - MIG-2027597 - Electro-Hydraulic Bullion Lift - Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out Maintenance items in accordance with Bureau Veritas report 9402 RBS0003-LKX1 - MIG-2027597 – 04/11/13 - 1. The corroded parts under the car should be suitably repaired and treated.[/TD]
[TD]05 Nov 2013 10:00[/TD]
[TD]13 Jun 2014 17:00[/TD]
[TD] [/TD]
[TD]P5 - 21 Working Days[/TD]
[TD] [/TD]
[TD]Statutory Testing & Inspection - Remedial Works - Tackle/Slings/Ropes/Other[/TD]
[TD]In Progress[/TD]
[TD]EAST[/TD]
[/TR]
[TR]
[TD]8751[/TD]
[TD]584814[/TD]
[TD]Mr Paulo Fernandes[/TD]
[TD]Steve White[/TD]
[TD]London[/TD]
[TD] [/TD]
[TD]WATFORD 74 HIGH STREET - 8751[/TD]
[TD]B defect Communication Device Job for Lift Maintenance contractor- 8751 - RBS0003LALA1- MIG-2026166 Task group STI. Priority P6 with response and completion time reduced to one month from when job is raised. Carry out Maintenance items in accordance with Bureau Veritas report 8751 - RBS0003LALA1- MIG-2026166- 04/11/13 3) The emergency communication alarm system in the car is inoperative and should be reinstated. – If it is determined that the phone-line is inoperative, Schindler to notify BV and advise line number, if known.[/TD]
[TD]05 Nov 2013 10:02[/TD]
[TD]04 Dec 2013 17:00[/TD]
[TD] [/TD]
[TD]P6 - 30 Working Days[/TD]
[TD] [/TD]
[TD]Statutory Testing & Inspection - Remedial Works - Lifts/Escalators/Hoists[/TD]
[TD]In Progress[/TD]
[TD]EAST[/TD]
[/TR]
[TR]
[TD]3967[/TD]
[TD]589345[/TD]
[TD]Mr Christopher Cusick[/TD]
[TD]John Rhodes[/TD]
[TD]North England[/TD]
[TD] [/TD]
[TD]LEIGH 32 MARKET STREET - 3967[/TD]
[TD]B DEFECT (non com) Job for Lift Maintenance contractor - 3967 RBS0003LAYG1 - MIG-2252486 - Electric Goods Lift - Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out Chargeable items in accordance with Bureau Veritas report 3967 RBS0003LAYG1 - MIG-2252486 - 11/11/2013 - 2. The damaged ground floor landing door lock cover should be renewed.[/TD]
[TD]12 Nov 2013 09:43[/TD]
[TD]14 Apr 2014 13:15[/TD]
[TD] [/TD]
[TD]P5 - 21 Working Days[/TD]
[TD] [/TD]
[TD]Statutory Testing & Inspection - Remedial Works - Lifts/Escalators/Hoists[/TD]
[TD]In Progress[/TD]
[TD]SCOTLAND & NORTH ENGLAND[/TD]
[/TR]
[TR]
[TD]1571[/TD]
[TD]590121[/TD]
[TD]Mr Jonathan Shepherd[/TD]
[TD]Jeffrey Ingham[/TD]
[TD]North England[/TD]
[TD] [/TD]
[TD]LEEDS HEADROW COURT - 1571[/TD]
[TD]B DEFECT (non com) Job for Lift Maintenance contractor - 1571 RBS0003LBFA4 - MIG-2100883 - Electric Passenger/Goods Lift 6 floors 0,1,2,3,4,5 - Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out Maintenance items in accordance with Bureau Veritas report 1571 RBS0003LBFA4 - MIG-2100883 - 11/11/2013 - 1. The loose handrail in the car should be secured. 3. The floor level indicators at the 1st and 4th floor landings are inoperative and should be reinstated.[/TD]
[TD]13 Nov 2013 09:28[/TD]
[TD]14 Apr 2014 17:00[/TD]
[TD] [/TD]
[TD]P6 - 30 Working Days[/TD]
[TD] [/TD]
[TD]Statutory Testing & Inspection - Remedial Works - Lifts/Escalators/Hoists[/TD]
[TD]In Progress[/TD]
[TD]SCOTLAND & NORTH ENGLAND[/TD]
[/TR]
[TR]
[TD]6198[/TD]
[TD]593342[/TD]
[TD]Mr Michael Lloyd[/TD]
[TD]Ian Ranger[/TD]
[TD]London[/TD]
[TD] [/TD]
[TD]CRAWLEY 16 THE BOULEVARD - 6198[/TD]
[TD]B DEFECT (non com) Job for Lift Maintenance contractor - 6198 RBS0003LAAX2 - MIG-2021542 - Electric Passenger/Goods Lift Lift 2 Staff Lift - Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out Maintenance items in accordance with Bureau Veritas report 6198 RBS0003LAAX2 - MIG-2021542 - 18/11/2013 - 2. The inoperative handwinding buzzer should be reinstated.[/TD]
[TD]19 Nov 2013 08:38[/TD]
[TD]19 Apr 2014 17:49[/TD]
[TD] [/TD]
[TD]P6 - 30 Working Days[/TD]
[TD] [/TD]
[TD]Statutory Testing & Inspection - Remedial Works - Lifts/Escalators/Hoists[/TD]
[TD]In Progress[/TD]
[TD]EAST[/TD]
[/TR]
[TR]
[TD]6198[/TD]
[TD]593346[/TD]
[TD]Mr Michael Lloyd[/TD]
[TD]Ian Ranger[/TD]
[TD]London[/TD]
[TD] [/TD]
[TD]CRAWLEY 16 THE BOULEVARD - 6198[/TD]
[TD]B DEFECT (non com) Job for Lift Maintenance contractor - 6198 RBS0003LAAX1 - MIG-2021541 - Electro-Hydraulic Passenger Lift Customer Lift - Task group STI. Priority P6 with response and completion time extended to five months from when job is raised. Carry out chargeable items in accordance with Bureau Veritas report 6198 RBS0003LAAX1 - MIG-2021541 - 18/11/2013 - 6. The missing bottom floor landing gate lock cover should be replaced.[/TD]
[TD]19 Nov 2013 08:39[/TD]
[TD]19 Apr 2014 17:09[/TD]
[TD] [/TD]
[TD]P6 - 30 Working Days[/TD]
[TD] [/TD]
[TD]Statutory Testing & Inspection - Remedial Works - Lifts/Escalators/Hoists[/TD]
[TD]In Progress[/TD]
[TD]EAST[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup>[/TABLE]




You can see that I need to populate the field requiring the equipment number but I don't know the lookup formula that will search the text in the description column for the Unique ID number that I've highlighted. The Unique Asset ID number is on sheet2, along with the equipment number that I need it to return to Sheet1. The only common value between the two sheets being the property number in column A, but I don't know if this is even relevant.

I don't have enough experience of using Macros or fully understand how they work to make the data pull through, so any help you can give would be greatly appreciated.

Whatever formula/macro we use, I must be able to transfer it easily and understand how it works as much as possible as I have to re-run the report every two weeks, and there is a lot more data than what is contained below.

Hopefully this makes more sense now.

Sheet2 looks like this.

[TABLE="width: 1232"]
<tbody>[TR]
[TD]Prop No[/TD]
[TD]dvj Order[/TD]
[TD]Contract Region[/TD]
[TD]Functional location[/TD]
[TD]Equipment Number[/TD]
[TD]Unique Asset ID[/TD]
[TD]BV Notes[/TD]
[TD]Unique I/D[/TD]
[TD]Autodialler telephone number[/TD]
[TD]SVP Property Status[/TD]
[TD]Product line[/TD]
[TD]Bldg Crit[/TD]
[TD]Total number of Lift units on Site[/TD]
[TD]Property Name[/TD]
[/TR]
[TR]
[TD]9402[/TD]
[TD="align: right"]217[/TD]
[TD]South, Ireland & Offshore[/TD]
[TD]10453436[/TD]
[TD]1228306[/TD]
[TD]RBS0003-LKX1[/TD]
[TD]MIG-2027597[/TD]
[TD]RBS0003LKX1[/TD]
[TD] [/TD]
[TD]CURRENT[/TD]
[TD]RETAIL[/TD]
[TD]F[/TD]
[TD]1[/TD]
[TD]LONDON HENDON 95 CHURCH ROAD - 9402[/TD]
[/TR]
[TR]
[TD]8751[/TD]
[TD="align: right"]189[/TD]
[TD]South, Ireland & Offshore[/TD]
[TD]10453400[/TD]
[TD]1229178[/TD]
[TD]RBS0003LALA1[/TD]
[TD]MIG-2026166[/TD]
[TD]RBS0003LALA1[/TD]
[TD] [/TD]
[TD]CURRENT[/TD]
[TD]RETAIL[/TD]
[TD]C[/TD]
[TD]1[/TD]
[TD]WATFORD 74 HIGH STREET - 8751[/TD]
[/TR]
[TR]
[TD]3967[/TD]
[TD="align: right"]778[/TD]
[TD]Scotland & North[/TD]
[TD]10453048[/TD]
[TD]1229487[/TD]
[TD]RBS0003LAYG1[/TD]
[TD]MIG-2252486[/TD]
[TD]RBS0003LAYG1[/TD]
[TD] [/TD]
[TD]CURRENT[/TD]
[TD]RETAIL[/TD]
[TD]F[/TD]
[TD]1[/TD]
[TD]LEIGH 32 MARKET STREET - 3967[/TD]
[/TR]
[TR]
[TD]1571[/TD]
[TD="align: right"]601[/TD]
[TD]Scotland & North[/TD]
[TD]10452867[/TD]
[TD]1229480[/TD]
[TD]RBS0003LBDL2[/TD]
[TD]MIG-2156346[/TD]
[TD]MissingMissing[/TD]
[TD] [/TD]
[TD]CURRENT[/TD]
[TD]MOP[/TD]
[TD]D-Alpha[/TD]
[TD]3[/TD]
[TD]LEEDS HEADROW COURT - 1571[/TD]
[/TR]
[TR]
[TD]1571[/TD]
[TD="align: right"]602[/TD]
[TD]Scotland & North[/TD]
[TD] [/TD]
[TD]1229481[/TD]
[TD]RBS0003LBFA3[/TD]
[TD]MIG-2100882[/TD]
[TD]RBS0003LBFA3[/TD]
[TD] [/TD]
[TD]CURRENT[/TD]
[TD]MOP[/TD]
[TD]D-Alpha[/TD]
[TD]3[/TD]
[TD]LEEDS HEADROW COURT - 1571[/TD]
[/TR]
[TR]
[TD]1571[/TD]
[TD="align: right"]603[/TD]
[TD]Scotland & North[/TD]
[TD] [/TD]
[TD]1229482[/TD]
[TD]RBS0003LBFA4[/TD]
[TD]MIG-2100883[/TD]
[TD]RBS0003LBFA4[/TD]
[TD] [/TD]
[TD]CURRENT[/TD]
[TD]MOP[/TD]
[TD]D-Alpha[/TD]
[TD]3[/TD]
[TD]LEEDS HEADROW COURT - 1571[/TD]
[/TR]
[TR]
[TD]6198[/TD]
[TD="align: right"]405[/TD]
[TD]South, Ireland & Offshore[/TD]
[TD]10453135[/TD]
[TD]1228686[/TD]
[TD]RBS0003LAAX1[/TD]
[TD]MIG-2021541[/TD]
[TD]RBS0003LAAX1[/TD]
[TD] [/TD]
[TD]CURRENT[/TD]
[TD]RETAIL[/TD]
[TD]C[/TD]
[TD]2[/TD]
[TD]CRAWLEY 16 THE BOULEVARD - 6198[/TD]
[/TR]
[TR]
[TD]6198[/TD]
[TD="align: right"]406[/TD]
[TD]South, Ireland & Offshore[/TD]
[TD] [/TD]
[TD]1228689[/TD]
[TD]RBS0003LAAX2[/TD]
[TD]MIG-2021542[/TD]
[TD]RBS0003LAAX2[/TD]
[TD] [/TD]
[TD]CURRENT[/TD]
[TD]RETAIL[/TD]
[TD]C[/TD]
[TD]2[/TD]
[TD]CRAWLEY 16 THE BOULEVARD - 6198[/TD]
[/TR]
</tbody><colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup>[/TABLE]




Thanks again for your help.

Regards
Steve
 
Upvote 0
You must log in or register to reply here.

Similar threads

M
  • Question Question
Search Cells for Partial Text in One Sheet and Return Value from Seperate Sheet
Replies
7
Views
586
Aladin Akyurek
Aladin Akyurek
SiuGuy007
  • Question Question
Count Cellls with Specific Text and Return the Summ of the Associated Values from Another Cell
Replies
3
Views
358
jtakw
jtakw
K
  • Question Question
Search Text in string and return a value from table
2
Replies
14
Views
2K
XOR LX
XOR LX
G
  • Question Question
Puzzled by move part of text from one cell to another
Replies
3
Views
1K
konew1
K
T
  • Question Question
Finding a cell amongst multiple rows/columns, then returning the value of a cell in that row from another column
Replies
2
Views
518
trillium
T

Forum statistics

Threads
1,223,902
Messages
6,175,278
Members
452,629
Latest member
SahilPolekar

Share this page

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