Worksheet name from cell contents?

  • Thread starter Thread starter Tobias Gårdner
  • Start date Start date
T

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
 
Hi Tobias
try
=IF(COUNTIF(INDIRECT("'" & A5 & "'!$C:$C");$C6);"*";"")
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Use Formula from another worksheet 3
Most common occurrence of a string 1
Using countif on non-consecutive cells 5
Possible to refer to a sheet's object name ? 1
Lookup of identical values? 3
Hide columns based on row values 2
using worksheet name in a formula but not current worksheet 3
CHAR(10) does not create new line in excel 2007 4

Back
Top