Having trouble using XLOOKUP between two spreadsheet files

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:

Please Login or Register  to view this content.

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)

Hi twalp, In my attachment I have included two different formulas (VLOOKUP) that seem to work. I only put formulas in the Daily Report so I did not attach the other one. Both reports will need to be open at the same time. The second set of formulas are indirect formulas.
As long as the IP list (IP List.xlsx) does not change names these should work.
Squeaky.

Thank you for replying, Squeaky. I prefer to stick with mastering and using XLOOKUP because it's more flexible that VLOOKUP. But I do appreciate your response!

Wow, TMS. Three different approaches - GREALY APPRECIATED! -- including a fix for my XLOOKUP formula.

Removing the "At sign" from the two Named columns was the fix for my example "Daily Report" sheet.

As you may have gathered from my post, I took the lazy approach of clicking on cells rather than manually entering the formula arguments. When I clicked on the two cells in "IP List" to get lookup_array and return_array the "At sign" was included, so I left it in because I don't know what the "At sign" indicates anyway !

Should the take-away from this be that "clicking on cells to build a formula works, but remove the 'At signs'"? Can you explain why the "At sign" was inserted but should not be used? Pardon my ignorance (and inability to get that answer from Google -- maybe I should try Bing's AI ?)

BONUS QUESTION: why does this forum block my submitting or even previewing this reply with the error message: "You are not allowed to post any kinds of links, images or videos until you post a few times." when I use the "At sign" in the text?!?

Wonderfully clear, TMS. Thank you!