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