Compare Excels using vlookup...comparison error

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…


Hi @suresh_kumar4

Check this

Ashwin S