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