Vlookup with nested if statement

[colmodoc]

Hi.
I would really appreciate assistance on what I believe will be a nested Vlookup and IF statement.
I wish to compare records in two separate lists using a VLookup. However I want to identify items (using Serial#) that appear in both lists where ownership is different in both lists.
Ownership is identified by email address.
Thank you!
See example:

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also what are your expected results with the data you have shown?

 

[colmodoc]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also what are your expected results with the data you have shown?

Thank you, Fluff.
Office 365 for macOS.

Expected results: I would like a statement in L6 to identify that the serial number in J6 exists in column E AND if where the email address for that item is different.
So the item in the above list that I'm interested in identifying is Serial # a13 where ownership has changed from Mary to Harry.
The result can be "Change of owner".

 

[Fluff]

Thanks for that, how about

=LET(x,XLOOKUP(J6,$E$6:$E$10,$F$6:$F$10,"",0),IF(x="","Not found",IF(x=K6,"Same","Change of Owner")))

 

[colmodoc]

Thanks for that, how about

=LET(x,XLOOKUP(J6,$E$6:$E$10,$F$6:$F$10,"",0),IF(x="","Not found",IF(x=K6,"Same","Change of Owner")))

Thank you Fluff.
I'm seeing the error #Name?

 

[shinigamilight]

L6: =IFERROR(IF(VLOOKUP(J6,$E$6:$F$10,2,0)=K6,"","Change of Owner"),"")

 

[Fluff]

I'm seeing the error #Name?

Are you sure you are using 365?

 

[colmodoc]

L6: =IFERROR(IF(VLOOKUP(J6,$E$6:$F$10,2,0)=K6,"","Change of Owner"),"")

View attachment 82624

Thank you!
Works a treat. Appreciate your help, Fluff, shinigamilight.

 

[Fluff]

Can you please answer my question?

 

[colmodoc]

Can you please answer my question?

Excel for mac Version 16.69, Fluff.