Hi,

I am using the following formula

=IF(INDIRECT("'"&$A4&"'!B4")="","",INDIRECT("'"&$A4&"'!B4"))

A4 has the name of the worksheet where the data that need to be searched is, B4 is the cell within that worksheet to retrieve the data from (if any is there).

I need to drag this formula across to the right up until AM4, whilst maintaining A4 - so my formula would look like this

=IF(INDIRECT("'"&$A4&"'!AM4")="","",INDIRECT("'"&$A4&"'!AM4"))

Any help on how to increment this part of the formula so that I can drag it across?

Many Thanks,
Hamish