Several if conditions - 2 same tables different data

[jutu]

Hi. I will try to explain it as clear as i can. Let's say I have an spreadsheet with 2 tabs for old and new data. Both tabs are the same tables with same headings and formats but just different data values.

I want to know if the row in the tab with old data values containing say row value 1335XY is in the other tab with new data values. Is there a way of doing this? Also, I only want to compare specific columns not the whole row. Basically it would be validation against the old/new data if that makes sense.

I've attached an excel example which I hope helps. Thanks

 

[ETAF]

what columns

you could use a countifs() and if Zero then different

=COUNTIFS($H$3:$H$6,A3,$I$3:$I$6,B3)

 

[vletm]

jutu​

Did You asked something like this?