Need help to compare data & display it in a particular format

Hi,

I would like to get the data displayed in a particular format in the column "Result" comparing two columns.I need to compare the values in Column A with the values in Column C when these values match then the values in Column B needs to be compared in Column D .When Column B and Column D matches the result must be displayed as "Same" ,When Column B doesn't match with Column D matches the result must be displayed as "Changed". When Column A doesn't match with Column C then the value must be displayed as "New"..

Note: The value in column A can match with the value in the column C at any instance , they can be present in the column C at any instance

Any help is appreciated

Not sure if I understand correctly, because I get a different answer for G5. (Don't know why it is "same").

But this is my suggestion.

Please Login or Register  to view this content.

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

Thanks for your reply sir..

This works out but i have a clause that the cell contents need not match exactly in the same row.In the attached excel the contents A6 & B6 match with C5 & D5 .In that case the result would be "Same" for G6.

The contents in C6&D6 may match with the contents on A7 &B7 (i have not included the contents for A7 & B7)

Any help in this regard is highly appreciated

Thanks Much

Originally Posted by FDibbins

Try this...
=IF(ISERROR(MATCH(D2&E2,INDEX($A$2:$A$6&$B$2:$B$6,0),0)),IF(ISERROR(MATCH(D2,$A$2:$A$6,0)),"New","changed"),"Same")
copied down

See the reply above sir...

any help in this regard is highly appreciated sir

I don't get it!

I tried Ford's formula and it worked, yours SEEMS to be the same, but I can't spot why it isn't working.

Please attach the actual sheet which is failing - perhaps we van then spot the reason.

Regards,

David

I tried on the same excel sheet which i attached ...

I am using Excel 2016 ...has it got anything to do with Office versions?

@ash81sen

It has nothing to do with versions. I am using XL2016 as well. I simply cut and pasted FDibbin's formula and it works. If you tried to type it, you may have missed a comma or something.

As I said before - supply a copy of the problem worksheet.