| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT Formula with an IF Then issue
Hi,
How do I get this formula to work: =IF((INDIRECT($B$3))&"!d6"="All",9999,0),=IF((INDI RECT($B$3))&"!d6"="222",go to cell y20) I want 9999 to show up if the word All is typed in a different worksheet. Otherwise, if 222 is typed in the cell d6, I want another cell's value to populate. Does that make sense? thanks, Eden 397 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
INDIRECT Formula with an IF Then issue
Maybe this:
=IF(INDIRECT("'"&$B$3&"'!D6")="All",9999,IF(INDIRE CT("'"&$B$3&"'!D6")=222,Y20,"")) -- Biff Microsoft Excel MVP "Eden397" wrote in message ... Hi, How do I get this formula to work: =IF((INDIRECT($B$3))&"!d6"="All",9999,0),=IF((INDI RECT($B$3))&"!d6"="222",go to cell y20) I want 9999 to show up if the word All is typed in a different worksheet. Otherwise, if 222 is typed in the cell d6, I want another cell's value to populate. Does that make sense? thanks, Eden 397 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
INDIRECT Formula with an IF Then issue
So far, I have gotten this far but I need one more indirect statement with
222 typed in where "All" or "Quota" is located. I also don't understand the "" that you wrote as coming before my $B$3. Thanks =IF((INDIRECT($B$3&"!d6"))="ALL",9999,IF((INDIRECT ($B$3&"!d6"))="Quota",(INDIRECT($B$3&"!Y8")))) "T. Valko" wrote: Maybe this: =IF(INDIRECT("'"&$B$3&"'!D6")="All",9999,IF(INDIRE CT("'"&$B$3&"'!D6")=222,Y20,"")) -- Biff Microsoft Excel MVP "Eden397" wrote in message ... Hi, How do I get this formula to work: =IF((INDIRECT($B$3))&"!d6"="All",9999,0),=IF((INDI RECT($B$3))&"!d6"="222",go to cell y20) I want 9999 to show up if the word All is typed in a different worksheet. Otherwise, if 222 is typed in the cell d6, I want another cell's value to populate. Does that make sense? thanks, Eden 397 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
INDIRECT Formula with an IF Then issue
I also don't understand the "" that you wrote as
coming before my $B$3. It's actually " ' ". This is needed if the sheet name contains a space. If the sheet name does not contain a space it does no harm. What should the result be if the cell = 222? -- Biff Microsoft Excel MVP "Eden397" wrote in message ... So far, I have gotten this far but I need one more indirect statement with 222 typed in where "All" or "Quota" is located. I also don't understand the "" that you wrote as coming before my $B$3. Thanks =IF((INDIRECT($B$3&"!d6"))="ALL",9999,IF((INDIRECT ($B$3&"!d6"))="Quota",(INDIRECT($B$3&"!Y8")))) "T. Valko" wrote: Maybe this: =IF(INDIRECT("'"&$B$3&"'!D6")="All",9999,IF(INDIRE CT("'"&$B$3&"'!D6")=222,Y20,"")) -- Biff Microsoft Excel MVP "Eden397" wrote in message ... Hi, How do I get this formula to work: =IF((INDIRECT($B$3))&"!d6"="All",9999,0),=IF((INDI RECT($B$3))&"!d6"="222",go to cell y20) I want 9999 to show up if the word All is typed in a different worksheet. Otherwise, if 222 is typed in the cell d6, I want another cell's value to populate. Does that make sense? thanks, Eden 397 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
INDIRECT Formula with an IF Then issue
If the cell contains "222" then the result will be the same as the "Quota"
cell number. It would be the same as the below statement but with "222" instead of "Quota". I need one more If Statement, I guess? =IF((INDIRECT($B$3&"!d6"))="ALL",9999,IF((INDIRECT ($B$3&"!d6"))="Quota",(INDIRECT($B$3&"!Y8")))) "T. Valko" wrote: I also don't understand the "" that you wrote as coming before my $B$3. It's actually " ' ". This is needed if the sheet name contains a space. If the sheet name does not contain a space it does no harm. What should the result be if the cell = 222? -- Biff Microsoft Excel MVP "Eden397" wrote in message ... So far, I have gotten this far but I need one more indirect statement with 222 typed in where "All" or "Quota" is located. I also don't understand the "" that you wrote as coming before my $B$3. Thanks =IF((INDIRECT($B$3&"!d6"))="ALL",9999,IF((INDIRECT ($B$3&"!d6"))="Quota",(INDIRECT($B$3&"!Y8")))) "T. Valko" wrote: Maybe this: =IF(INDIRECT("'"&$B$3&"'!D6")="All",9999,IF(INDIRE CT("'"&$B$3&"'!D6")=222,Y20,"")) -- Biff Microsoft Excel MVP "Eden397" wrote in message ... Hi, How do I get this formula to work: =IF((INDIRECT($B$3))&"!d6"="All",9999,0),=IF((INDI RECT($B$3))&"!d6"="222",go to cell y20) I want 9999 to show up if the word All is typed in a different worksheet. Otherwise, if 222 is typed in the cell d6, I want another cell's value to populate. Does that make sense? thanks, Eden 397 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
INDIRECT Formula with an IF Then issue
Try this:
=IF(INDIRECT($B$3&"!D6")="ALL",9999,IF(OR(INDIRECT ($B$3&"!D6")={"Quota",222}),INDIRECT($B$3&"!Y8")," ")) -- Biff Microsoft Excel MVP "Eden397" wrote in message ... If the cell contains "222" then the result will be the same as the "Quota" cell number. It would be the same as the below statement but with "222" instead of "Quota". I need one more If Statement, I guess? =IF((INDIRECT($B$3&"!d6"))="ALL",9999,IF((INDIRECT ($B$3&"!d6"))="Quota",(INDIRECT($B$3&"!Y8")))) "T. Valko" wrote: I also don't understand the "" that you wrote as coming before my $B$3. It's actually " ' ". This is needed if the sheet name contains a space. If the sheet name does not contain a space it does no harm. What should the result be if the cell = 222? -- Biff Microsoft Excel MVP "Eden397" wrote in message ... So far, I have gotten this far but I need one more indirect statement with 222 typed in where "All" or "Quota" is located. I also don't understand the "" that you wrote as coming before my $B$3. Thanks =IF((INDIRECT($B$3&"!d6"))="ALL",9999,IF((INDIRECT ($B$3&"!d6"))="Quota",(INDIRECT($B$3&"!Y8")))) "T. Valko" wrote: Maybe this: =IF(INDIRECT("'"&$B$3&"'!D6")="All",9999,IF(INDIRE CT("'"&$B$3&"'!D6")=222,Y20,"")) -- Biff Microsoft Excel MVP "Eden397" wrote in message ... Hi, How do I get this formula to work: =IF((INDIRECT($B$3))&"!d6"="All",9999,0),=IF((INDI RECT($B$3))&"!d6"="222",go to cell y20) I want 9999 to show up if the word All is typed in a different worksheet. Otherwise, if 222 is typed in the cell d6, I want another cell's value to populate. Does that make sense? thanks, Eden 397 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| INDIRECT.EXT issue | Excel Discussion (Misc queries) | |||
| indirect formula | Excel Worksheet Functions | |||
| indirect formula help | Excel Worksheet Functions | |||
| indirect formula | Excel Worksheet Functions | |||
Hybrid Mode
