Need help to create macro to find and replace if conditions are met

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Need help to create macro to find and replace if conditions are met

04-19-2019, 06:45 AM

p45cal

Windows 10 Need help to create macro to find and replace if conditions are met

Office 2016

Expert

Join Date: Apr 2014

Posts: 956

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.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and Replace Macro Need	djpemberton	Word VBA	2	05-04-2016 07:53 PM
Looking for code to create a macro that prompts user to enter text, then does a find/replace.	sfvegas	PowerPoint	0	01-08-2016 02:22 AM
Find and Replace Macro	amparete13	PowerPoint	3	03-11-2014 05:29 AM
macro or find/replace	JamesVenhaus	Word	2	02-27-2012 03:34 PM
Find and Replace Macro - A Better Way	Tribos	Word VBA	0	10-08-2008 03:22 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:03 PM.