Mastersheet

[srctr]

I am creating a master sheet and I have that it creates a list of sheet names
then use indirect to reference sheet names and the appropriate cell in the
sheet. Can I add text to the equation? For example the equation
=INDIRECT("'"&A5&"'!B39") gives me my Invoice Number from that worksheet -
225. But I would like to add to it the text "Invoice# OSC-00"

So that my answer would be Invoice #OSC-00225

 

[Don]

you should be able to add at the begining of your formula

="Invoice# "&

and put the indirect part after

 

[srctr]

That worked perfect, Thanks!
--
cao

you should be able to add at the begining of your formula

="Invoice# "&

and put the indirect part after