Formula for comparing values in two worksheet

[haadiya]

Hi all,Can someone help me on this.I want a formula for the below scenario

I have sheet 1 in which Ii have

A B C
NAME TYPE VALUE
lock_name_space 2
processes 3 200
sessions 3 324
timed_statistics 1 TRUE
and in sheet2 I have

A B C
NAME TYPE VALUE
processes 3 200
sessions 3 324
timed_statistics 1 FALSE
I want a formula to compare A of sheet 1 with A of sheet2,if it is present in sheet 2 of A then check its value(ie C column) is same if same return TRUE else FALSE eg.In sheet1 I have timed_statistics 1 TRUE ,in sheet 2 I have timed_statistics 1 FALSE and in sheet1 I have lock_name_space and in sheet 2 I dont have lock_name_space

[Vikas_Gautam]

Try this in sheet2 D2:-

Please Login or Register  to view this content.

[TMS]

You could use something like this, assuming the data is in columns A to C

Please Login or Register  to view this content.

See the attached example.

Regards, TMS