Hi Guys,
I am using vlookup to compare 2 excel files with columns in it…
column1 in excel1…
column1 in excel2.
i am getting the result but in some places it the data mismatches its showing match
i have around 500 rows…i am using this vlookup expression…
“=IF(ISNA(VLOOKUP(A2,‘D:\UI_Path\UI_Forum\lookup1[File3.xlsx]Sheet1’!$A$2:$A$1000,1,TRUE)), ““Match””, ““Not Match””)”
please help me out .thanks…
Thanks,
Suresh.