Worksheet name variables
You can use the €śIndirect€ť function to get the name of the worksheet into a
formula. Assume the name of the worksheet is in cell A9, this formula should
do what you want:
=IF(INDIRECT((A9)&"!$R$9")=$C$2,INDIRECT((A9)&"!$N $9"),0)
Tom
|