Excel not recognizes lose as a match

[cdmafra]

Hello.

I downloaded an Excel fixture and I adapted it for another championship (less teams, less fixtures). I'm experiencing a problem that is: Excel not recognizes loses as matches for the looser team. The draws and wins are normal.

The file is attached. Please help me, I really need this table ready for the next days. Thank you in advance

CNS Série F.zip

[XOR LX]

Hi,

Sorry but there's quite a lot to look at in that file. Can you tell me specifically which cells I should be looking at, and what the results should be?

Regards

[FDibbins]

Where is this formula you have a problem with? I can see a bunch of vlookups and names, apart from that, everything is protected?

[cdmafra]

It's not everything protected.
The problem is in the "Tabela" book/tab

[RobertMika]

You have hidden Sheet "Setting" which is protected.

[XOR LX]

"The problem is in the "Tabela" book/tab"

Sorry, but could you please try and be a bit more helpful?

The only formulas in that particular tab refer to a sheet called 'Setting' (incidentally, along with not mentioning the protection you have in this workbook, you also chose not to mention that this sheet was hidden), and you have not given any indication of which particular cells are the problem, nor what that problem is, beyond saying: "Excel not recognizes loses as matches for the looser team".

Regards

[cdmafra]

Sorry, I don't understand too much about Excel. I only identified the problem that is in the Sheet "Tabela".

If a team starts the championship with a lose, it will appear in the table ("Tabela") as "0" until a draw or win. I identified now the "Setting" sheet but I don't understand about that... what Must I change?

Ah! The error only happens when I cut games from the 18 teams original fixture (I have 5 games instead 9 as in original file)
CNS Série F.zip