Hi
if you would use INDIRECT it may be possible. e.g. try in B1:
=IF(ISERROR(INDIRECT("'" & A1 & "'!D10")),"ERROR in
sheetname",If(INDIRECT("'" & A1 & "'!D10")= 3, F10*16))
--
Regards
Frank Kabel
Frankfurt, Germany
"Todd L." schrieb im Newsbeitrag
...
I have one column with worksheet names in it and a second column with
formulas that use the adjacent worksheet name. Is there a formula or
a way
to use conditional formatting to check if the formulas have the
correct sheet
name in them?
Column A Column B
Apexel If(Apexel ! D10 = 3, F10*16)
TIA
Todd
|