=IF(ISERROR(VLOOKUP($B6,'09.12.11'!$B$3:$D$17,3,0)),0,(VLOOKUP($B6,'09.12.11'!$B$3:$D$17,3,0)))

Hi there,

Please help if you can! And accept my apologies if this has already been posted but am pretty new on this forum.

I have a file wirth one main tab and other data tabs that I add daily.
On my main tab, all I do is copying the formula of the last column and I need to change the tab name in the formula, '09.12.11' by '12.12.11' for example.
Precision, all my tabs are in the same file next to each other!!
But if I change the tab name, manually or using the find&replace, Excel start to get crazy and wants to open other files!
I don't understand what the problem is, why make it complicated when it is simple?
Is there an option I need to change if my Excel?

Many thanks!
Mayya