Compare Columns From 2 Sheets

Hello

I have 2 Sheets Fee collection and Sheet2

Fee Collection is Collection of All India Which is Handling by Me

Sheet 2 is Also Fee Collection but they are Divide into 4 Zones i.e. North,South,East,West

On Daily Basis i have Receive Sheet from All the 4 Zones, and i have to Check Whether the My Sheet (Fee Collection Master) is Map With Sheet2 (Received from Zones)

I have to Check Through Column B to Column K

Some Time i am Wrong and Some time Zones are Wrong , In that Case i Check The Details from Accounts and Correct our Reports

Right Now, i am using "=" to Compare the Data

Is there any Other Options to Compare data , If they Met it Shows "TRUE" Otherwise "FALSE"

Thanks in Advance

Hardeep

That was Awesome

Thanks Dude

You are a Life Saver

Regards

Hardeep:

=INDEX('Fee Collection Master'!$A:$K, MATCH(UPPER($B3), 'Fee Collection Master'!$B$4:$B$100, 0)+3, COLUMN())=C3

Sorry for Disturb u

Could you pls explain what is +3

=INDEX('Fee Collection Master'!$A:$K,MATCH(UPPER($B3),'Fee Collection Master'!$B$4:$B$100,0)+3,COLUMN())=C3