I have an #ref error on my file

Iron Contributor

I have an #ref error on my file it on opponents and make sure away or home section working

 

 

 

Thanks You

 

2 Replies
I do not see any #ref error to your file. Everything looks fine to me. What is your excel version? You need Microsoft-365 as it is using FILTER(), XLOOKUP(), TAKE() functions which are only available to Microsoft-365.

Look at bills worksheet