formula error

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

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
 
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
 
Heather said:
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
Click to expand...

Maybe this:

=INDIRECT("'"&DealPlatformType&" Platform'!C11")
 
What is DealPlatformType?

Maybe this:

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

INDIRECT("'"

That's double quote single quote double quote: " ' "
 
Thank you!!! made all the difference

Jacob Skaria said:
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
Click to expand...
 
Back
Top