Need to know if you can use a cell value as a sheet name in an IF statement

[Grant22]

Hello all, I am trying to write a quick if statement to reference a sheet by the same name in my workbook. So I already have a sub that fills column A with all the sheet names in my workbook, I was wondering if I could then use that Cell value to reference the sheet I want to pull info from. Here's the formula I'm getting an error on:

=IF(ISBLANK(A11),0,SHEETS("A11")!S15)
In this example, Cell A11 has the name "Sample" in it which is also the name of the sheet I want to pull info from.

The statement below works but it hard codes the name Sample as the sheet name, if I can pull it from a cell I can then just drag it across and down to make things faster.

=IF(ISBLANK(A11),0,Sample!S15)

Anyone know a way to use the cell value as reference?

 

[AliGW]

You need to investigate the INDIRECT function: http://www.contextures.com/xlFunctions05.html