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