please help me in this thread

[khalil]

hi all
please help

i want to replace the question mark in the formula below in one cell with a text from another cell in the same workbook once i print a text in the other cell (automatically).

thanks

=IF(OR('Fill Info.'!L8="?")*AND('Fill Info.'!Z8<"s"),'Fill Info.'!F8,"")

 

[jasonb75]

Enter the other cell into the formula

=if(and('Fill Info.'!L8='other sheet'!A1,'Fill Info.'!Z8<"s"),'Fill Info.'!F8,"")

 

[khalil]

Enter the other cell into the formula

=if(and('Fill Info.'!L8='other sheet'!A1,'Fill Info.'!Z8<"s"),'Fill Info.'!F8,"")

it did not work with me
thanks any way

 

[jasonb75]

Did you change the red bit?

 

[khalil]

Enter the other cell into the formula

=if(and('Fill Info.'!L8='other sheet'!A1,'Fill Info.'!Z8<"s"),'Fill Info.'!F8,"")

after dealing with the formula it does work
i apresiate your help thank you very much