Mastersheet
 

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

--
cao

Mastersheet
 

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

="Invoice# "&

and put the indirect part after

"srctr" wrote:

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

--
cao

Mastersheet
 

That worked perfect, Thanks!
--
cao


"Don" wrote:

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

="Invoice# "&

and put the indirect part after

"srctr" wrote:

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

--
cao