Intermittent Index/Match problem

[Shaun]

Hi All

I have a situation where an Index/Match evaluates to #N/A for each column in the same row. For each B1 value the #N/A will shift rows or not be present at all!

I have tried re-entering affected data manually, but this does not correct the issue. I have rechecked the formula and it appears to be correct. I do not understand what is happening.

Does anyone have any ideas as to what might cause of the error?

Cheers

Shaun

 

[Somendra Misra]

Hi Shaun,

Try this Change the refrence of named range lstRaceId to =Odds_Odds!$C$2:$C$7201

Regards,

 

[Hui]

Shaun

Your Named Formula lstRaceId
should be: =Odds_Odds!$C$2:$C$7201

 

[Shaun]

I can't believe I missed that.

Thank you.