Match ID number from One list with another list

[hafe4k]

I'm trying to get a match using the ID number as the unique identifier.

I've tried doing this but doesn't work:
=XLOOKUP(J6,$E$6:$F$751,$B$6:$F$751,"",0)

Any help please - note they are not both in the same order, and List 1 is usually has more data than list 2:

List 1:
Column B: Title Name
Column C: Name
Column D: Address
Column E: ID Number
Column F: Area

List 2:
Column J has the ID number (to help match with Column E)
*MUST HAVE* - Column K - should show match the 'Title Name' match of Column B from List 1.

If possible would also like to see:
*NICE TO HAVE* - Column L - match the 'Area' match of Column F from List 1.

 

[Fluff]

How about

=XLOOKUP(J6,$E$6:$E$751,$B$6:$B$751,"",0)

 

[hafe4k]

Thank you

 

[Fluff]

You're welcome & thanks for the feedback.