Hi,

Am Wed, 20 Feb 2013 05:22:47 -0800 (PST) schrieb AA Arens:

try:

=IF(ISERROR(MATCH($A1&" "&$B1,fsr.csv!$B$2:$B$2000&" "&fsr.csv!$C$2:$C$2000,0)),"Changed","")

Regards

Claus Busch

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

Claus, thank you for your reply. The formula always gives "changed" event though the respective values in the row are the same as the values in another row from the CSV.

I have removed the &" " (space), is that correct?

What I am looking for is a two formulas in two cells in the row of the XLS file:

One cell indicates that the first value differs in either of the sheet while the other values was equal, and in another cell an indication that the second value was different while the first value remained the same.

It is not possible that both has changed (then the combination cannot be found either)

CSV:

Array with sample values in the columns:

10 54 67

11 76 44

5 100 32

XLS:

10 33 67 "changed" "same"

11 76 88 "same" "changed"

5 100 32 "same" "same"