What condition you need to check in the column A and column B
Any mapping condition or what
If Mapping you can read two sheets & use select command.
Hi Thanks arivu, I need if else condition
if materialID is 241 and action is empty then Changed result in message column
if maretialID is 242 and action is X then deleted result in message column
if both column is empty then created result in message column