Reply With Quote
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.
thx sambit, value at the end of formula mean look at the whole row in column A ($A:$A) ?Originally Posted by sambit
ISNUMBER used to check numeric value, my excelsheet contain string, can i use ISNUMBER too?
yes, you can.
Alternative option:
you can also try vlookup function.
Posting Permissions
Bookmarks