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. Also, I don' know VBA. ha
Formula:
IF tab2/tab3 A:A matches tab 1 A:3 data
THEN compare column B data between tab2/tab3
IF match then populate column B data into tab 1 column B
IF in variance then populate "variance" into tab 1 column B
Tab 1 (comparative tab). Contains unique identifier in column A
Tab 2. Contains unique identifier in column A
Tab 3. Contains unique identifier in column A
Formula:
IF tab2/tab3 A:A matches tab 1 A:3 data
THEN compare column B data between tab2/tab3
IF match then populate column B data into tab 1 column B
IF in variance then populate "variance" into tab 1 column B
Tab 1 (comparative tab). Contains unique identifier in column A
Tab 2. Contains unique identifier in column A
Tab 3. Contains unique identifier in column A
Anchor | RECORD_TYPE | SOURCE | REPORT_PERIOD_ID | PYMT_SCHED_ID | AGREEMENT_ID | PROPERTY_ID |
APO102752APO102752 | ||||||
10535.S.014.S.836 D009000480 | ||||||
10535.S.014.S.838 D009000492 | ||||||
10535.S.014.S.498 D009000497 | ||||||
10535.S.014.492 D010003305 | ||||||
PO3000103498PO3000103498 |