Lookup value based on criteria

Hi,

I have problem to understand which kind of formula to use.

I have 2 sheets with the same 2 columns in each:

Unique ID and Region.

I would like to compare the two sheets ans see if any Id has changed region.

Which formula should i use?

Thanks Bertrand

If there is only one same ID on both sheets then you could use:

Formula:

Please Login or Register  to view this content.

(replace ; with , if you get error)

Result will give you TRUE if there is Unique ID founded and with same region.
Otherwise FALSE

If ID is in column A and region is in column B,

Then is sheet2 column C,

Formula:

Please Login or Register  to view this content.

It returns true if the values are same.

Exact function worked more simple and worked perfectly.

Thank you both!