Index function stopped working

[SanjayGMusafir]

Hi Experts

Everything was going fine. Just now the following formula stopped working. I checked it, part by part. The INDEX function is giving error.

In fact I realized the problem when found one of the Macro using same formula was not working as intended.

Any suggestions

Thanks in advance

=HYPERLINK("#"&
ADDRESS(MATCH(1,Index((Banks[Dt]>=TODAY())*(Banks[Dt]<=TODAY()+15),0,1),0)+5,COLUMN(Banks[Dt]),4,1),
ADDRESS(MATCH(1,Index((Banks[Dt]>=TODAY())*(Banks[Dt]<=TODAY()+15),0,1),0)+5,COLUMN(Banks[Dt]),4,1))

 

[SanjayGMusafir]

I believe I downloaded some data from internet that might have corrupted the file or what.

With some effort I reverted back to few hours back and everything was working fine.

Thanks for checking through my post. Marking thread resolved.

Yet any concrete answer to what could have happened might help in future.

Thanks again.

 

[Joe4]

I have found that data downloaded from the internet often has issues, such as:
- Numeric or date data coming over as text, instead of in a valid number or date format
- Data have special non-visible characters in them, such as non-breaking spaces. This can be especially troublesome when trying to match on data.

 

[SanjayGMusafir]

@Joe4 the challenge was the data downloaded was all together at some different place in the file and yet...

Still the thoughts you have shared are worth keeping in mind for future references too.

Thanks again

 

[Joe4]

@Joe4 the challenge was the data downloaded was all together at some different place in the file and yet...

Not quite sure what you mean by that?

However, your formula is doing date math/comparisons. If the data you downloaded came down as text and not as valid dates, that could cause issues.

I am just telling you what problem I commonly see with data downloaded from the web. Maybe it pertains to you in this situation, maybe it does not.
But since you don't have any explanation yet, and asked for possible causes, I thought I would mention that.