I have a problem with this formula :

=IF($F$5='\\S154-0106\Data\Personeel\Uurroosters\2012\[Uurrooster 2012.xls]JAN'!$E$25;1,1;0). This formula returns the value '1,1'
Deze formule werkt perfect.

Now I want to assemble the cell reference myself, something like this :
=IF($F$5="'\\S154-0106\Data\Personeel\Uurroosters\2012\[Uurrooster 2012.xls]JAN'!$E$"&P1;1,1;0)
Value of P1 is 25.

I would expect that the result of this formula would return '1,1' as well, but instead it returns '0'

When I try this formula: ="'\\S154-0106\Data\Personeel\Uurroosters\2012\[Uurrooster 2012.xls]JAN'!$E$"&P1 it return the following value :: '\\S154-0106\Data\Personeel\Uurroosters\2012\[Uurrooster 2012.xls]JAN'!$E$25 instead of the value of this cell.

Has it something to do with the brackets ? Anyone ideas ?

Thanx