Worksheet name from cell contents?

[Tobias Gårdner]

Hi,

I have the following forumula in my worksheet:
=IF(COUNTIF('Single host'!$C:$C;$C6);"*";"")

I would like the 'Single host' to be a reference, i.e. A5.

Is this possible?

Regards Tobbe

 

[Frank Kabel]

Hi Tobias
try
=IF(COUNTIF(INDIRECT("'" & A5 & "'!$C:$C");$C6);"*";"")