Thread: formula error
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default 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