formula error
 

Does anyone see what's wrong with this formula

=INDIRECT(""&DealPlatformType&" Platform'!C11")

I am referencing Cell B4 in my worksheet (DealPlatformType) and then want it
to add a space and the word Platform so that it can go to the tab in Cell C11
to return an amount

Thank you

formula error
 

Copy the below formula and try

=INDIRECT("'"&DealPlatformType&" Platform'!C11")

" ' " Please note that i have inserted spaces in between for you understand
the difference.

If this post helps click Yes
---------------
Jacob Skaria


"Heather" wrote:

Does anyone see what's wrong with this formula

=INDIRECT(""&DealPlatformType&" Platform'!C11")

I am referencing Cell B4 in my worksheet (DealPlatformType) and then want it
to add a space and the word Platform so that it can go to the tab in Cell C11
to return an amount

Thank you

formula error
 

Heather wrote:
Does anyone see what's wrong with this formula

=INDIRECT(""&DealPlatformType&" Platform'!C11")

I am referencing Cell B4 in my worksheet (DealPlatformType) and then want it
to add a space and the word Platform so that it can go to the tab in Cell C11
to return an amount

Thank you

Maybe this:

=INDIRECT("'"&DealPlatformType&" Platform'!C11")

formula error
 

What is DealPlatformType?

Maybe this:

=INDIRECT("'"&DealPlatformType&" Platform'!C11")

INDIRECT("'"

That's double quote single quote double quote: " ' "


--
Biff
Microsoft Excel MVP


"Heather" wrote in message
...
Does anyone see what's wrong with this formula

=INDIRECT(""&DealPlatformType&" Platform'!C11")

I am referencing Cell B4 in my worksheet (DealPlatformType) and then want
it
to add a space and the word Platform so that it can go to the tab in Cell
C11
to return an amount

Thank you

formula error
 

Thank you!!! made all the difference

"Jacob Skaria" wrote:

Copy the below formula and try

=INDIRECT("'"&DealPlatformType&" Platform'!C11")

" ' " Please note that i have inserted spaces in between for you understand
the difference.

If this post helps click Yes
---------------
Jacob Skaria


"Heather" wrote:

Does anyone see what's wrong with this formula

=INDIRECT(""&DealPlatformType&" Platform'!C11")

I am referencing Cell B4 in my worksheet (DealPlatformType) and then want it
to add a space and the word Platform so that it can go to the tab in Cell C11
to return an amount

Thank you