Dear experts
I have N number of workbooks saved in path, i want lookup criteria through A&H columns value if not met criteria update remarks in I column
like for e.g In the lookup table:
FR CHINA = INDO CHINA
ORPH CHINA = INDO CHINA
In A= FR CHINA, H=INDO CHINA
A=ORPH CHINA,H=CHINA Here remarks = Wrong Country Update
path is C:\Users\Admin\Desktop\FY16\ALL FILES R XLSB
find the attachment
Bookmarks