how to compare 2 excel file?

03042015

New member
Joined
Apr 3, 2015
Messages
2
Reaction score
0
Points
0
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.
 

Attachments

  • FILE 1.xlsx
    9.5 KB · Views: 7
  • FILE 2.xlsx
    8.2 KB · Views: 8
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) ?
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.
 
Back
Top