Hi,
Try below formula
=ISNUMBER(MATCH(A2,'[FILE 2.xlsx]Sheet1'!$A:$A,0))
which is not matching with File 2 it comes False.
plz see the attachment.
i have 2 excel file
file1
fieldA fieldB fieldC fieldD
file2
columnA columnB columnC columnD
each file contain around 300 row and impossible to check using side by side view
is there any formula to make it easy?
i.e open file1 and read file2 from file 1 using formulas?
thx
Hi,
Try below formula
=ISNUMBER(MATCH(A2,'[FILE 2.xlsx]Sheet1'!$A:$A,0))
which is not matching with File 2 it comes False.
plz see the attachment.
yes, you can.
Alternative option:
you can also try vlookup function.
Bookmarks