Hello,

I am trying to create a formula with the INDIRECT or OFFSET command so my
cells will reflect the cell at the address I am calling on instead of the one
I deleted. My formula also needs to show the result of another cell if there
is something in the cell and nothing if the cell is blank. Are there any
Excel Wizards out there who can help? I have tried several things with the
#REF! as my result. I am using Excel 2003 and my formula I am trying to
modify with INDIRECT is:

=IF(AND(BOM!A261,TAKESTOCK!A16<""),BOM!$D$5,"")

FYI: BOM is my first sheet, TAKESTOCK is the sheet that I am trying to
modify and the cell this formula is on is TAKESTOCK A17.

Thank you,
Shane