Formula for comparing values in two worksheet

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

Nick's picture

try: =iferror(match(

try: =iferror(match(