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
|