No response from index/match returning values from a structured table

[JeffGrant]

Hi All,

I have an odd and was wondering if anybody has seen this.

I have formula:

=IFERROR(INDEX(RemoveScratchingsFromTodaysField[Json.Horse],MATCH(1,('Todays Field List'!$AR$6=RemoveScratchingsFromTodaysField[Json.RaceId])*('Todays FieldList'!$AS3=RemoveScratchingsFromTodaysField[Json.Barrier]),0)),"")

This formula has worked for over year without any problems.
Last week is stopped working and was just erroring out
Last night, I retyped it, exactly the same as it has always been and now it works again.
Because this is an automated model, I wasn't aware that this formula stopped.
Any and all ideas are graciously recieved.

 

[SanjayGMusafir]

I'm never so good at Index-Match. It confuses me, until I need it very badly.

With Excel 365 in your hand why don't you try with XLOOKUP. It shall make your life much easier I believe.

 

[JeffGrant]

Hi Sanjay, XLookup has many advantages, I agree. Index/Match is slightly faster. In this model, Xlookup does not offer any advantage that would warrant the time required to convert it or rewite the code in the back end.

Cheers