Hi Col O,R,S.T have "0" or an email address down to row 2500
How can I get it to check in Col U if there is an email address in the above cols and if it does return the email address in U
Many thanks
Assuming only one cell in O, R, S or T will contain an email address, just check each cell for "not equal to 0". =IF(O3<>0,O3,IF(R3<>0,R3,IF(S3<>0,S3,IF(T3<>0,T3,""))))
If more than one cell might contain an email address, you'll only get the first one.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.
