Hello,
This is what I am trying to do:
IF ((the value at Sheet3!G2 is found in Sheet2!G) AND (the value in
Sheet2!H? is not empty )
THEN
copy the value of Sheet2!H? to Sheet3!H2
ELSE IF ((the value at Sheet3!G2 is found in Sheet1!A) AND (the value
in Sheet1!F? is not empty )
THEN
copy the value of Sheet1!F? to Sheet3!H2
Many thanks,
Justin
This is what I am trying to do:
IF ((the value at Sheet3!G2 is found in Sheet2!G) AND (the value in
Sheet2!H? is not empty )
THEN
copy the value of Sheet2!H? to Sheet3!H2
ELSE IF ((the value at Sheet3!G2 is found in Sheet1!A) AND (the value
in Sheet1!F? is not empty )
THEN
copy the value of Sheet1!F? to Sheet3!H2
Many thanks,
Justin