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