I have to provide a quick report every morning with a list of outstanding alarms on equipment. Based on this list troubles are prioritized and techs are dispatched to make repairs. This can mean that some of these alarms will remain on the list for varying periods of time until the tech is able to correct the issue. Using VLOOKUP I look back at the previous sheet in the workbook to pull the dates forward for any issues that have not been resolved. This worked great for weeks, but recently the VLOOKUP started to fail. It works for about 113 rows of alarms and then it quits bringing the dates forward. Using IFERROR it would insert the current day's date. The raw data comes in the form of text that delimited by a semi colon and is pasted into columns E & F, which is a unique number for the equipment and the alarm for that equipment. Column A is hidden and blank for future use, this puts the dates in column B. Can anyone help me understand why it just stops on row 113. The IFERROR has been removed because it was putting the current date in for everything.
=VLOOKUP(E111&F111,'03-15'!$A$3:$L$1000,2,FALSE)
[TABLE="width: 843"]
<tbody>[TR]
[TD="class: xl67, width: 89"]Date[/TD]
[TD="class: xl67, width: 64"]CDMA[/TD]
[TD="class: xl69, width: 256"]Name[/TD]
[TD="class: xl68, width: 33"]Cell[/TD]
[TD="class: xl67, width: 401"]
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 843"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]3/15/2018[/TD]
[TD]68764[/TD]
[TD]Buena Vista[/TD]
[TD]845[/TD]
[TD]ASMB 1, RRH 6, TX VSWR ALARM MINOR[/TD]
[/TR]
[TR]
[TD]3/14/2018[/TD]
[TD]68780[/TD]
[TD]Holly[/TD]
[TD]852[/TD]
[TD]ASMB 1, RRH 5, DIVERSITY IMBALANCE RX1/RX2 MINOR ALARM[/TD]
[/TR]
[TR]
[TD]3/12/2018[/TD]
[TD]68878[/TD]
[TD]Pembroke[/TD]
[TD]854[/TD]
[TD]ASMB 1, RRH 5, DIVERSITY IMBALANCE RX1/RX2 MINOR ALARM[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]68882[/TD]
[TD]Vinton / Seibel Rd.[/TD]
[TD]860[/TD]
[TD]ASMB 1, RUI 1, PORT 2, FRAMING ERROR MAJOR[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]68882[/TD]
[TD]Vinton / Seibel Rd.[/TD]
[TD]860[/TD]
[TD]ASMB 1, RRH 2, INDETERMINATE CRITICAL[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]68882[/TD]
[TD]Vinton / Seibel Rd.[/TD]
[TD]860[/TD]
[TD]ASMB 1, RRH 2, CARRIER 1, PAF 2, NO PILOT[/TD]
[/TR]
</tbody>[/TABLE]
=VLOOKUP(E111&F111,'03-15'!$A$3:$L$1000,2,FALSE)
[TABLE="width: 843"]
<tbody>[TR]
[TD="class: xl67, width: 89"]Date[/TD]
[TD="class: xl67, width: 64"]CDMA[/TD]
[TD="class: xl69, width: 256"]Name[/TD]
[TD="class: xl68, width: 33"]Cell[/TD]
[TD="class: xl67, width: 401"]
[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 843"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD]3/15/2018[/TD]
[TD]68764[/TD]
[TD]Buena Vista[/TD]
[TD]845[/TD]
[TD]ASMB 1, RRH 6, TX VSWR ALARM MINOR[/TD]
[/TR]
[TR]
[TD]3/14/2018[/TD]
[TD]68780[/TD]
[TD]Holly[/TD]
[TD]852[/TD]
[TD]ASMB 1, RRH 5, DIVERSITY IMBALANCE RX1/RX2 MINOR ALARM[/TD]
[/TR]
[TR]
[TD]3/12/2018[/TD]
[TD]68878[/TD]
[TD]Pembroke[/TD]
[TD]854[/TD]
[TD]ASMB 1, RRH 5, DIVERSITY IMBALANCE RX1/RX2 MINOR ALARM[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]68882[/TD]
[TD]Vinton / Seibel Rd.[/TD]
[TD]860[/TD]
[TD]ASMB 1, RUI 1, PORT 2, FRAMING ERROR MAJOR[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]68882[/TD]
[TD]Vinton / Seibel Rd.[/TD]
[TD]860[/TD]
[TD]ASMB 1, RRH 2, INDETERMINATE CRITICAL[/TD]
[/TR]
[TR]
[TD]#N/A[/TD]
[TD]68882[/TD]
[TD]Vinton / Seibel Rd.[/TD]
[TD]860[/TD]
[TD]ASMB 1, RRH 2, CARRIER 1, PAF 2, NO PILOT[/TD]
[/TR]
</tbody>[/TABLE]