If cells contains this, do this until...

[tblackwell]

Hi - Newbie here. Read the FAQs, rules and searched the forum and did not find an answer so created a new post. Bear with me.

Question: If cell's contains this do this until...
Hypothetical Example: Trying to write a formula to look for characters that begin with 6, then return the first four characters of that cell.
I got that but here is where I get stuck: If does not begin with 6, then use first four characters of cell that does begin with 6 UNTIL it finds a new number
Current formula where I get stuck: =IF(LEFT(C14,1)="6",LEFT(C14,4),C13)
System: Windows 10 Pro

	C	M	N	O	P	Q	R	S	T	U	V	W	X
Reference Cells	My Formula	What I Want
6001 24 Highway - 2192
L-FREE-CHIKNWFRYDRNK	6001 24 Highway - 2192
L-FREE-SINGLE FRYDRK	L-FREE-CHIKNWFRYDRNK
N-0200-OFF FULLSALAD	L-FREE-SINGLE FRYDRK
N-0200-OFFCOMBO	N-0200-OFF FULLSALAD
N-BOGO-3PC TENDERS	N-0200-OFFCOMBO
N-BOGO-CHICKEN	N-BOGO-3PC TENDERS
N-BOGO-SINGLECHEESE	N-BOGO-CHICKEN
N-DISC-2SGLCHZ CMB	N-BOGO-SINGLECHEESE
N-DISC-2SPC CHK CMB	N-DISC-2SGLCHZ CMB
N-DISC-DBL CHZ CMB	N-DISC-2SPC CHK CMB
N-DISC-KM CHICKEN	N-DISC-DBL CHZ CMB
N-DISC-KM CHK TENDER	N-DISC-KM CHICKEN
N-DISC-KM CHZBURGER	N-DISC-KM CHK TENDER
N-DISC-KM HAMBURGER	N-DISC-KM CHZBURGER
N-DISC-KM NUGGET	N-DISC-KM HAMBURGER
N-DISC-KM WRAPS	N-DISC-KM NUGGET
N-FREE-COOKIE	N-DISC-KM WRAPS
N-FREE-JRFRSTYKEYTAG	N-FREE-COOKIE
N-FREE-TNDRSW/FRYDRK	N-FREE-JRFRSTYKEYTAG
6001 24 Highway - 2192 Quantity:
6002 40 Highway - 8246
L-FREE-CHIKNWFRYDRNK	6002 40 Highway - 8246
L-FREE-SINGLE FRYDRK	L-FREE-CHIKNWFRYDRNK
N-0200-OFF FULLSALAD	L-FREE-SINGLE FRYDRK
N-0200-OFFCOMBO	N-0200-OFF FULLSALAD
N-BOGO-3PC TENDERS	N-0200-OFFCOMBO
N-BOGO-CHICKEN	N-BOGO-3PC TENDERS
N-BOGO-SINGLECHEESE	N-BOGO-CHICKEN
N-DISC-2SGLCHZ CMB	N-BOGO-SINGLECHEESE
N-DISC-2SPC CHK CMB	N-DISC-2SGLCHZ CMB
N-DISC-DBL CHZ CMB	N-DISC-2SPC CHK CMB
N-DISC-KM CHICKEN	N-DISC-DBL CHZ CMB
N-DISC-KM CHK TENDER	N-DISC-KM CHICKEN
N-DISC-KM CHZBURGER	N-DISC-KM CHK TENDER
N-DISC-KM HAMBURGER	N-DISC-KM CHZBURGER
N-DISC-KM NUGGET	N-DISC-KM HAMBURGER
N-DISC-KM WRAPS	N-DISC-KM NUGGET
N-FREE-COOKIE	N-DISC-KM WRAPS
N-FREE-JRFRSTYKEYTAG	N-FREE-COOKIE
N-FREE-TNDRSW/FRYDRK	N-FREE-JRFRSTYKEYTAG
6002 40 Highway - 8246 Quantity:
6003 State Ave - 2183
L-FREE-CHIKNWFRYDRNK	6003 State Ave - 2183
L-FREE-SINGLE FRYDRK	L-FREE-CHIKNWFRYDRNK

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]13[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]23[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]24[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]25[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]26[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]27[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]28[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]29[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]30[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]31[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]32[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]33[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]34[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6001[/TD]
[TD="align: right"][/TD]

[TD="align: center"]35[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]36[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]37[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]38[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]39[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]40[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]41[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]42[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]43[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]44[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]45[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]46[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]47[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]48[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]49[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]50[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]51[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]52[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]53[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]54[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]55[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6002[/TD]
[TD="align: right"][/TD]

[TD="align: center"]56[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]

[TD="align: center"]57[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]

[TD="align: center"]58[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"]6003[/TD]
[TD="align: right"][/TD]

</tbody>

ToFormat​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C14[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A10="",'[Promotion Detail_twb.xls]Sheet1'!B10,'[Promotion Detail_twb.xls]Sheet1'!A10)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C15[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A11="",'[Promotion Detail_twb.xls]Sheet1'!B11,'[Promotion Detail_twb.xls]Sheet1'!A11)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C16[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A12="",'[Promotion Detail_twb.xls]Sheet1'!B12,'[Promotion Detail_twb.xls]Sheet1'!A12)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C17[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A13="",'[Promotion Detail_twb.xls]Sheet1'!B13,'[Promotion Detail_twb.xls]Sheet1'!A13)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C18[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A14="",'[Promotion Detail_twb.xls]Sheet1'!B14,'[Promotion Detail_twb.xls]Sheet1'!A14)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C19[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A15="",'[Promotion Detail_twb.xls]Sheet1'!B15,'[Promotion Detail_twb.xls]Sheet1'!A15)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C20[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A16="",'[Promotion Detail_twb.xls]Sheet1'!B16,'[Promotion Detail_twb.xls]Sheet1'!A16)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C21[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A17="",'[Promotion Detail_twb.xls]Sheet1'!B17,'[Promotion Detail_twb.xls]Sheet1'!A17)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C22[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A18="",'[Promotion Detail_twb.xls]Sheet1'!B18,'[Promotion Detail_twb.xls]Sheet1'!A18)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C23[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A19="",'[Promotion Detail_twb.xls]Sheet1'!B19,'[Promotion Detail_twb.xls]Sheet1'!A19)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C24[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A20="",'[Promotion Detail_twb.xls]Sheet1'!B20,'[Promotion Detail_twb.xls]Sheet1'!A20)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C25[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A21="",'[Promotion Detail_twb.xls]Sheet1'!B21,'[Promotion Detail_twb.xls]Sheet1'!A21)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C26[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A22="",'[Promotion Detail_twb.xls]Sheet1'!B22,'[Promotion Detail_twb.xls]Sheet1'!A22)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C27[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A23="",'[Promotion Detail_twb.xls]Sheet1'!B23,'[Promotion Detail_twb.xls]Sheet1'!A23)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C28[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A24="",'[Promotion Detail_twb.xls]Sheet1'!B24,'[Promotion Detail_twb.xls]Sheet1'!A24)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C29[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A25="",'[Promotion Detail_twb.xls]Sheet1'!B25,'[Promotion Detail_twb.xls]Sheet1'!A25)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C30[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A26="",'[Promotion Detail_twb.xls]Sheet1'!B26,'[Promotion Detail_twb.xls]Sheet1'!A26)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C31[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A27="",'[Promotion Detail_twb.xls]Sheet1'!B27,'[Promotion Detail_twb.xls]Sheet1'!A27)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C32[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A28="",'[Promotion Detail_twb.xls]Sheet1'!B28,'[Promotion Detail_twb.xls]Sheet1'!A28)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C33[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A29="",'[Promotion Detail_twb.xls]Sheet1'!B29,'[Promotion Detail_twb.xls]Sheet1'!A29)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C34[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A30="",'[Promotion Detail_twb.xls]Sheet1'!B30,'[Promotion Detail_twb.xls]Sheet1'!A30)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C35[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A31="",'[Promotion Detail_twb.xls]Sheet1'!B31,'[Promotion Detail_twb.xls]Sheet1'!A31)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C36[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A32="",'[Promotion Detail_twb.xls]Sheet1'!B32,'[Promotion Detail_twb.xls]Sheet1'!A32)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C37[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A33="",'[Promotion Detail_twb.xls]Sheet1'!B33,'[Promotion Detail_twb.xls]Sheet1'!A33)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C38[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A34="",'[Promotion Detail_twb.xls]Sheet1'!B34,'[Promotion Detail_twb.xls]Sheet1'!A34)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C39[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A35="",'[Promotion Detail_twb.xls]Sheet1'!B35,'[Promotion Detail_twb.xls]Sheet1'!A35)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C40[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A36="",'[Promotion Detail_twb.xls]Sheet1'!B36,'[Promotion Detail_twb.xls]Sheet1'!A36)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C41[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A37="",'[Promotion Detail_twb.xls]Sheet1'!B37,'[Promotion Detail_twb.xls]Sheet1'!A37)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C42[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A38="",'[Promotion Detail_twb.xls]Sheet1'!B38,'[Promotion Detail_twb.xls]Sheet1'!A38)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C43[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A39="",'[Promotion Detail_twb.xls]Sheet1'!B39,'[Promotion Detail_twb.xls]Sheet1'!A39)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C44[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A40="",'[Promotion Detail_twb.xls]Sheet1'!B40,'[Promotion Detail_twb.xls]Sheet1'!A40)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C45[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A41="",'[Promotion Detail_twb.xls]Sheet1'!B41,'[Promotion Detail_twb.xls]Sheet1'!A41)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C46[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A42="",'[Promotion Detail_twb.xls]Sheet1'!B42,'[Promotion Detail_twb.xls]Sheet1'!A42)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C47[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A43="",'[Promotion Detail_twb.xls]Sheet1'!B43,'[Promotion Detail_twb.xls]Sheet1'!A43)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C48[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A44="",'[Promotion Detail_twb.xls]Sheet1'!B44,'[Promotion Detail_twb.xls]Sheet1'!A44)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C49[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A45="",'[Promotion Detail_twb.xls]Sheet1'!B45,'[Promotion Detail_twb.xls]Sheet1'!A45)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C50[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A46="",'[Promotion Detail_twb.xls]Sheet1'!B46,'[Promotion Detail_twb.xls]Sheet1'!A46)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C51[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A47="",'[Promotion Detail_twb.xls]Sheet1'!B47,'[Promotion Detail_twb.xls]Sheet1'!A47)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C52[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A48="",'[Promotion Detail_twb.xls]Sheet1'!B48,'[Promotion Detail_twb.xls]Sheet1'!A48)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C53[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A49="",'[Promotion Detail_twb.xls]Sheet1'!B49,'[Promotion Detail_twb.xls]Sheet1'!A49)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C54[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A50="",'[Promotion Detail_twb.xls]Sheet1'!B50,'[Promotion Detail_twb.xls]Sheet1'!A50)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C55[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A51="",'[Promotion Detail_twb.xls]Sheet1'!B51,'[Promotion Detail_twb.xls]Sheet1'!A51)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C56[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A52="",'[Promotion Detail_twb.xls]Sheet1'!B52,'[Promotion Detail_twb.xls]Sheet1'!A52)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C57[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A53="",'[Promotion Detail_twb.xls]Sheet1'!B53,'[Promotion Detail_twb.xls]Sheet1'!A53)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C58[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A54="",'[Promotion Detail_twb.xls]Sheet1'!B54,'[Promotion Detail_twb.xls]Sheet1'!A54)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C59[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A55="",'[Promotion Detail_twb.xls]Sheet1'!B55,'[Promotion Detail_twb.xls]Sheet1'!A55)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C60[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A56="",'[Promotion Detail_twb.xls]Sheet1'!B56,'[Promotion Detail_twb.xls]Sheet1'!A56)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C61[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A57="",'[Promotion Detail_twb.xls]Sheet1'!B57,'[Promotion Detail_twb.xls]Sheet1'!A57)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C62[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A58="",'[Promotion Detail_twb.xls]Sheet1'!B58,'[Promotion Detail_twb.xls]Sheet1'!A58)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C63[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A59="",'[Promotion Detail_twb.xls]Sheet1'!B59,'[Promotion Detail_twb.xls]Sheet1'!A59)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C64[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A60="",'[Promotion Detail_twb.xls]Sheet1'!B60,'[Promotion Detail_twb.xls]Sheet1'!A60)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C65[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A61="",'[Promotion Detail_twb.xls]Sheet1'!B61,'[Promotion Detail_twb.xls]Sheet1'!A61)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C66[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A62="",'[Promotion Detail_twb.xls]Sheet1'!B62,'[Promotion Detail_twb.xls]Sheet1'!A62)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C67[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A63="",'[Promotion Detail_twb.xls]Sheet1'!B63,'[Promotion Detail_twb.xls]Sheet1'!A63)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C68[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A64="",'[Promotion Detail_twb.xls]Sheet1'!B64,'[Promotion Detail_twb.xls]Sheet1'!A64)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C69[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A65="",'[Promotion Detail_twb.xls]Sheet1'!B65,'[Promotion Detail_twb.xls]Sheet1'!A65)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C70[/TH]
[TD="align: left"]=IF('[Promotion Detail_twb.xls]Sheet1'!A66="",'[Promotion Detail_twb.xls]Sheet1'!B66,'[Promotion Detail_twb.xls]Sheet1'!A66)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S14[/TH]
[TD="align: left"]=IF(LEFT(C14,1)="6",LEFT(C14,4),C13)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S15[/TH]
[TD="align: left"]=IF(LEFT(C15,1)="6",LEFT(C15,4),C14)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S16[/TH]
[TD="align: left"]=IF(LEFT(C16,1)="6",LEFT(C16,4),C15)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S17[/TH]
[TD="align: left"]=IF(LEFT(C17,1)="6",LEFT(C17,4),C16)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S18[/TH]
[TD="align: left"]=IF(LEFT(C18,1)="6",LEFT(C18,4),C17)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S19[/TH]
[TD="align: left"]=IF(LEFT(C19,1)="6",LEFT(C19,4),C18)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S20[/TH]
[TD="align: left"]=IF(LEFT(C20,1)="6",LEFT(C20,4),C19)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S21[/TH]
[TD="align: left"]=IF(LEFT(C21,1)="6",LEFT(C21,4),C20)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S22[/TH]
[TD="align: left"]=IF(LEFT(C22,1)="6",LEFT(C22,4),C21)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S23[/TH]
[TD="align: left"]=IF(LEFT(C23,1)="6",LEFT(C23,4),C22)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S24[/TH]
[TD="align: left"]=IF(LEFT(C24,1)="6",LEFT(C24,4),C23)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S25[/TH]
[TD="align: left"]=IF(LEFT(C25,1)="6",LEFT(C25,4),C24)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S26[/TH]
[TD="align: left"]=IF(LEFT(C26,1)="6",LEFT(C26,4),C25)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S27[/TH]
[TD="align: left"]=IF(LEFT(C27,1)="6",LEFT(C27,4),C26)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S28[/TH]
[TD="align: left"]=IF(LEFT(C28,1)="6",LEFT(C28,4),C27)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S29[/TH]
[TD="align: left"]=IF(LEFT(C29,1)="6",LEFT(C29,4),C28)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S30[/TH]
[TD="align: left"]=IF(LEFT(C30,1)="6",LEFT(C30,4),C29)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S31[/TH]
[TD="align: left"]=IF(LEFT(C31,1)="6",LEFT(C31,4),C30)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S32[/TH]
[TD="align: left"]=IF(LEFT(C32,1)="6",LEFT(C32,4),C31)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S33[/TH]
[TD="align: left"]=IF(LEFT(C33,1)="6",LEFT(C33,4),C32)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S34[/TH]
[TD="align: left"]=IF(LEFT(C34,1)="6",LEFT(C34,4),C33)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S35[/TH]
[TD="align: left"]=IF(LEFT(C35,1)="6",LEFT(C35,4),C34)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S36[/TH]
[TD="align: left"]=IF(LEFT(C36,1)="6",LEFT(C36,4),C35)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S37[/TH]
[TD="align: left"]=IF(LEFT(C37,1)="6",LEFT(C37,4),C36)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S38[/TH]
[TD="align: left"]=IF(LEFT(C38,1)="6",LEFT(C38,4),C37)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S39[/TH]
[TD="align: left"]=IF(LEFT(C39,1)="6",LEFT(C39,4),C38)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S40[/TH]
[TD="align: left"]=IF(LEFT(C40,1)="6",LEFT(C40,4),C39)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S41[/TH]
[TD="align: left"]=IF(LEFT(C41,1)="6",LEFT(C41,4),C40)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S42[/TH]
[TD="align: left"]=IF(LEFT(C42,1)="6",LEFT(C42,4),C41)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S43[/TH]
[TD="align: left"]=IF(LEFT(C43,1)="6",LEFT(C43,4),C42)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S44[/TH]
[TD="align: left"]=IF(LEFT(C44,1)="6",LEFT(C44,4),C43)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S45[/TH]
[TD="align: left"]=IF(LEFT(C45,1)="6",LEFT(C45,4),C44)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S46[/TH]
[TD="align: left"]=IF(LEFT(C46,1)="6",LEFT(C46,4),C45)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S47[/TH]
[TD="align: left"]=IF(LEFT(C47,1)="6",LEFT(C47,4),C46)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S48[/TH]
[TD="align: left"]=IF(LEFT(C48,1)="6",LEFT(C48,4),C47)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S49[/TH]
[TD="align: left"]=IF(LEFT(C49,1)="6",LEFT(C49,4),C48)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S50[/TH]
[TD="align: left"]=IF(LEFT(C50,1)="6",LEFT(C50,4),C49)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S51[/TH]
[TD="align: left"]=IF(LEFT(C51,1)="6",LEFT(C51,4),C50)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S52[/TH]
[TD="align: left"]=IF(LEFT(C52,1)="6",LEFT(C52,4),C51)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S53[/TH]
[TD="align: left"]=IF(LEFT(C53,1)="6",LEFT(C53,4),C52)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S54[/TH]
[TD="align: left"]=IF(LEFT(C54,1)="6",LEFT(C54,4),C53)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S55[/TH]
[TD="align: left"]=IF(LEFT(C55,1)="6",LEFT(C55,4),C54)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S56[/TH]
[TD="align: left"]=IF(LEFT(C56,1)="6",LEFT(C56,4),C55)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S57[/TH]
[TD="align: left"]=IF(LEFT(C57,1)="6",LEFT(C57,4),C56)[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]S58[/TH]
[TD="align: left"]=IF(LEFT(C58,1)="6",LEFT(C58,4),C57)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[jtakw]

Re: If cell's contains this, do this until...

Try this, I hid some rows and added some data as shown in your OP, formula copied down:

Book1
	A	S
1
2	6001 Highway - 2192	6001
3		6001
4		6001
5	5/24/2018 Total:	6001
6		6001
7		6001
8	5/25/2018 Total:	6001
29	6/1/2018 Total:	6001
30		6001
31		6001
32	6/2/2018 Total:	6001
56	6/9/2018 Total:	6001
57		6001
58		6001
59	6/10/2018 Total:	6001
60		6001
61		6001
62	6/11/2018 Total:	6001
63		6001
64		6001
65	6/12/2018 Total:	6001
66		6001
67		6001
68		6001
69	6/13/2018 Total:	6001
91	6/20/2018 Total:	6001
92		6001
93	6001 24 Highway - 2192 Quantity:	6001
94	6002 40 Highway - 8246	6002
95	6002 40 Highway - 8246	6002
96	L-FREE-CHIKNWFRYDRNK	6002
97	L-FREE-SINGLE FRYDRK	6002
98	N-0200-OFF FULLSALAD	6002
99	N-0200-OFFCOMBO	6002
100	N-BOGO-3PC TENDERS	6002
101	N-BOGO-CHICKEN	6002
102	6003 State Ave - 2183	6003
103	L-FREE-CHIKNWFRYDRNK	6003
104	L-FREE-SINGLE FRYDRK	6003
Sheet480

Cell Formulas
Range	Formula
S2	=IF(AND(FIND(" ",A2&" ")=5,LEFT(A2&6)="6"),LEFT(A2,4)+0,S1)

Change/adjust cell references as needed.

 

[tblackwell]

Re: If cell's contains this, do this until...

Add an additional constraint that the value has to be less than 7,000? Excel sees dates as numbers so 1=1/1/1900 and june 2018 is that 43,000ish you're getting.

That's a super good idea, except it is returning false. What am I doing wrong?

=IF(AND(ISNUMBER(VALUE(LEFT(A5,4))),LEFT(A5,4)<=7000),VALUE(LEFT(A5,4)),FALSE)

 

[Kamolga]

Re: If cell's contains this, do this until...

That is strange:

=[COLOR=#ff0000][FONT=Verdana]ISNUMBER([/FONT][/COLOR][COLOR=green][COLOR=#008000][FONT=Verdana]VALUE([COLOR=purple]LEFT([COLOR=teal]A194,4[/COLOR])[/COLOR])[/FONT][/COLOR][/COLOR]

gives false for a date, even if it is June or the 6th day of month (my settings are European so dd/mm/yy).

There is a way to check if A194 is a date with

[COLOR=#242729][FONT=Consolas]=IF(LEFT(CELL("format",[FONT=Verdana][COLOR=#008080]A194[/COLOR][/FONT]))="D"[/FONT][/COLOR]

So maybe this would work with your date format

[COLOR=#242729][FONT=Consolas]=IF(and(LEFT(CELL("format",[FONT=Verdana][COLOR=#008080]A194[/COLOR][/FONT]))<>"D",[FONT=Verdana][COLOR=#ff0000]ISNUMBER([/COLOR][/FONT][COLOR=green]VALUE([COLOR=purple]LEFT([FONT=Verdana][COLOR=#008080]A194[/COLOR][/FONT][COLOR=teal],4[/COLOR])[/COLOR])[/COLOR][FONT=Verdana][COLOR=#ff0000]),LEFT([/COLOR][/FONT][FONT=Verdana][COLOR=#008080]A194[/COLOR][/FONT][COLOR=green],1[/COLOR][FONT=Verdana][COLOR=#ff0000])="6"[/COLOR][/FONT][COLOR=#0000ff][FONT=Verdana]),VALUE([COLOR=red]LEFT([COLOR=#008080]A194[/COLOR][COLOR=green],4[/COLOR])[/COLOR][FONT=Verdana][COLOR=#0000ff]),S194[/COLOR][/FONT][/FONT][/COLOR][COLOR=#0000ff][FONT=Verdana][COLOR=#333333][FONT=Verdana])[/FONT][/COLOR][/FONT][/COLOR][/FONT][/COLOR]