Compare and look for data across two tabs *UPDATED*

Hello all,

I have stripped my data down.

I have made two tabs for data which is for two different regisions (UK and Irnternational)

On the UK tab, I am looking to have a formula in Cell J2 which checks cells A2 on the UK and Intenrational tabs, and returns the value "NULL on both", if the cells C2 on both tabs says "NULL", returns the value "NULL" on UK and IS NOT NULL on Int tab cell C2... or vice versa.

Same process I want a formula in cell K2 which checks cells A2 on the UK and Intenrational tabs, and returns the value "NULL on both", if the cells G2 on both tabs says "NULL", returns the value "NULL" on UK and IS NOT NULL on Int tab cell C2... or vice versa.

I have no idea where to start

Thank you!


EDITED:

Hi all,

I am now sharing v2 of the file. I have put in index matches in column j2 and k2 aon both tabs. Can someone suggest how I can write a formula in L2 and M2 to point out whether data from c2 and g2 on each tab are matching or not matching?

TY!

??
J2:
=IF(VLOOKUP(A2,INT!$A:$C,3,FALSE)&B2="NULLNULL","Null on both",B2)

k2:
=IF(VLOOKUP(A2,INT!$A:$G,7,FALSE)&B2="NULLNULL","Null on both",B2)

Your explanation on what you want on the INT sheet was not clear. The formulae there may need a tweak.

Hi Glenn

Thank you for your input I am trying to amend and update the foprmula because I am checking cell C2 on both tabs and cell G2 on both tabs.

I am happy to amend the spreadsheet to bring both tables onto one tab, I just need a way of comparing the two...

No not needed. I just dont know what you expect ro see on INT. Does my formula do what you want? If not what should it do?

A few rows plus expected answers, instead of one with no expected results always helps...

Hi Glenn

Mayube my thinking is wrong and I`m trying a nerw direction but basically how about on the INT TAB it returns this:

Column C check (so it is checking against cell A2, and returning the result of C2 from the UK tab)
NULL (as in A2 from the INT tab which was looked for in UK tab, and returned the value from C2 of NULL)

Column G check (so it is checking against cell A2, and returning the result of G2 from the UK tab)
NULL (as in A2 from the INT tab which was looked for in UK tab, and returned the value from G2 of 123456 for example)

Column M: if there was a match i.e. C2 on both tabs have a MATCH/same value, write MATCH, if there is no MATCH, return the different values shown in C2 from both tabs
Column N: if there was a match i.e. G2 on both tabs have a MATCH/same value, write MATCH, if there is no MATCH, return the different values shown in C2 from both tabs

I`m open to suggestions hope this helps thjank you so much

My head is going in circles trying to intepret ONE sample.

If this is incorrect, please do as I asked at post 4.... provide several rows, NO formulae plus expected results.

It is SO much easier if you SHOW US what you want.