Thanks for using JustAnswer. My name isXXXXX will do whatever I can to answer your question =IF(LEN(Sheet1!B1)=0,Sheet1!A1,Sheet2!D1)REMEMBER THAT JUST ANSWER IS A PAID SERVICEPLEASE RATE "OK" OR HIGHER SO THAT I AM PAID FOR MY TIMEBONUS ALSO APRECIATED
hi Andrew, the formula does work until the value in sheet one changes
thanks but i have modified it slightly and it now works.
Attachments are only available to registered users.
no worries, will do thank you.