|
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 |
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 |
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 |
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 |
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 |
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 |
INDIRECT Formula with an IF Then issue
You, my friend, are awesome! I will get to sleep easily for a change
tonight! Thank you very much. "T. Valko" wrote: 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 |
INDIRECT Formula with an IF Then issue
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Eden397" wrote in message ... You, my friend, are awesome! I will get to sleep easily for a change tonight! Thank you very much. "T. Valko" wrote: 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 |
| All times are GMT +1. The time now is 10:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com