| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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") |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If formula error | Excel Worksheet Functions | |||
| Formula Error | Excel Worksheet Functions | |||
| =IF formula #NAME? error | Excel Worksheet Functions | |||
| =IF formula #NAME? error | Excel Worksheet Functions | |||
| How do I replace "#N/A" error, to continue my formula w/o error? | Excel Worksheet Functions | |||
Linear Mode
