data comparative between multiple tabs

[Pizzio]

I'm looking for a formula that compares data between two sheets. If the data matches then TRUE, if not then FALSE. The columns could have text or values.

Tab 1. Contains reference point in column A. Formulas in column B through Z will be comparing tab 2 and 3 column data such as does tab 2 and 3 column B both have the word EXCEL when the reference point matches in tab 1
Tab 2. Contains reference point in column A.
Tab 3. Contains reference point in column A.

 

[Pizzio]

Would =IF(ISNA(MATCH work over multiple tabs for this?

 

[Pizzio]

This might be easier to follow. Each tab will have the same headers

Anchor	Notes	RECORD_TYPE	SOURCE	REPORT_PERIOD_ID	PYMT_SCHED_ID	AGREEMENT_ID	PROPERTY_ID
APO102752APO102752
10535.S.014.S.836 D009000480		IF tab2/tab3 A:A matches A:3
10535.S.014.S.838 D009000492		THEN compare C3 data between tab2/tab3
10535.S.014.S.498 D009000497		IF match then populate C3 data
10535.S.014.492 D010003305		IF in variance then "variance"
PO3000103498PO3000103498