Thread
:
Need help to create macro to find and replace if conditions are met
View Single Post
04-19-2019, 06:45 AM
p45cal
Windows 10
Office 2016
Expert
Join Date: Apr 2014
Posts: 866
Do you need a macro?
In row 2 of any column beyond column C:
Code:
=IF(AND(A2="aa",ISNUMBER(MATCH(B2,$C$1:$C$5,0))),"yy",A2)
copy down.
Then copy|paste-special values over column A.
p45cal
View Public Profile
Find all posts by p45cal