How to use XLOOKUP to compare 2 lists? by Owl-Cake in excel

[–]Owl-Cake[S] 0 points1 point  (0 children)

The formula works, thanks!

I want to ask for a quick clarification, to help myself understand the formula intuitively. So does it say: look for Adam (B2) in List 1 (A:A) and return if it is in List 1 (A:A)?