IFERROR INDEX script stop working

Good afternoon everyone

I got help setting up this Formula a few months ago and the last week it stopped working
I'm very new at index match formulas learning as I go
the code below is in Sheet Timeslot Tracker report Cell M2 and goes down the page

Please Login or Register  to view this content.

The problem I have is it is showing LOAD NUMBER NOT FOUND! on everything even when the load number is on Date sheet

When I do a check on Date I can see the load number there not sure why this is getting a error
If this code needs to be changed in any way I don't mine

any help would be great

Bo_Ry

You are the best
I never understood why excel cant see the difference from text and numbers as to us they look the same

I just run use this on a few of the sheets some work and some don't I think I have a mix of both text and numbers mixed in with each other on some of the sheets
I have another company that provides the information

Is there a way for this formula to see both text and numbers and return all the information

I have this set up inside VBA which I run every morning

Please Login or Register  to view this content.

looking back at the old code

Please Login or Register  to view this content.

B2&"" and B2= looks like it tried to tell that difference from text to numbers then it stopped working

Bo_Ry

You are the best
I never understood why excel cant see the difference from text and numbers as to us they look the same

I just run use this on a few of the sheets some work and some don't I think I have a mix of both text and numbers mixed in with each other on some of the sheets
I have another company that provides the information

Is there a way for this formula to see both text and numbers and return all the information
I have uploaded another sheet that has both mixed one after testing both Formula
I have place each formula in there own column M and O for you so you can see side by side results

I have conditional formatting set up when a result returns as this report gets sent off to our customer every 2 hours

I have this set up inside VBA which I run every morning

Please Login or Register  to view this content.

looking back at the old code

Please Login or Register  to view this content.

B2&"" and B2= looks like it tried to tell that difference from text to numbers then it stopped working

This is Awesome Bo_Ry

I have not heard of the AGGREGATE formula I will look in to this
I run all of the last 2 weeks and none of them gave load number not found

I will update my VBA will let you know if I run in to any problems

Thanks for all your help and support
JustinwB