#REF! with cell value check

[Shane White]

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!A26>1,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

[CRIMEDOG]

you don't need takestock!a17 if the formula is on takestock - you only need a17. When do you get the #ref error? After your deletion?
I am not sure I know what you want.

[shg]

CRIMEDOG,

I think it's unlikely that Shane will be checking back to answer questions about his 4 1/2 year old post.