VBA Code replace old values to new values depends upon column values

Dear experts

I have set of data which require vba to complete the task .

Task : select column E:E source, Select Processed by Others towards column A:A Accountant check with list accountant
if names found out of list mark remark as accountant Not in List from sheet list.

LIke Processed by others in A:A col is Venkat & Ramya is not list of accountant so need to mark as accountant not in list.

pls find the attachment.

VBA?

Place the formula in I2 and copy down

PHP Code: 

=REPT("Accountant no in List",ISERROR(MATCH(A2,List!A:A,0))) 


Hi johnlara,
maybe so

Please Login or Register  to view this content.

If vba, no need to loop.

Please Login or Register  to view this content.

Amazing Experts!! Thanks to all