I have two spreadsheet files: "Daily Report" and "IP List". Both are two column tables.

"IP List" is a reference sheet that contains a list of all possible IP addresses and its associated user.

IP List.xlsx

"Daily Report" changes every day because it shows a list of the active IP addresses on that day. My goal with it is to find those IP addresses in "IP List" and display its associated user.

Daily Report.xlsx

I thought it would be a simple matter of entering the following formula into column two of the "Daily Report" by clicking on the cells in both sheets that will supply the needed arguments.

What I mean is, I type =XLOOKUP( in B2 of "Daily Report".
then click on A2 of the "Daily Report" to provide the "lookup_value"
then click on A2 in the "IP List" table to provide the "lookup_array"
then click on B2 in the "IP List" table to provide the "return_array"
and complete the formula with "" for "if not found".

Doing that creates the following formula:

Well, oops, this forum won't allow me to show the formula because it triggers "You are not allowed to post any kinds of links, images or videos until you post a few times."  So please look at it in the attached "Daily Report" spreadsheet.
I cannot post a screenshot of the result either, but only one person is displayed in "Daily Report", cell B2. The rest of the rows return blanks even though the IPs are valid.

What am I doing wrong? (both spreadsheets are attached)