I have 2 excels (1 is main excel, second is check excel) , what I need is compare these 2 datatables’ “Material” column. On the matching rows I want to write match/no match to “State” column on the main excel.
I want to do it without using loops. I know there is a way to do it but I dont know how
I appreciate every bit of help