I have this working well:

=if('Lee''s sheet'!$AP2="x",'Lee''s sheet'!B2,"")

which will populate cell values into a cell, from 1 sheet to another if there is an "X" marked in column AP.

I want to run the same formula but if ANY text or number is AP column (as opposed to just an X)

1 Answer 1


Test for the length of the cell contents; it is is greater than zero, then B2, else ""

The specific sheet reference is untested, but taken from your example.

=if(len('Lee''s sheet'!$AP2)>0,'Lee''s sheet'!B2,"")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.