I am having an issue with XLOOKUP. I think it is a formatting issue.
In the attached file, "By Position" tab, I am trying to match the "Name" value to the Name in the "Top 200" tab "Player" column.
I only have one match since I copied "Josh Allen" from the "By Position" tab to the "Top 200" tab.
I've tried TRIM and clearing formats.
I tried copy/paste value to another tab and nothing works.
Not sure why the calculations didn't update, but in the attached file (with ranges transformed to structured tables) seems to work. Though, the ones at the bottom don't seem to have a match. Hence, #N/A.
Thank you Riny.
What do you mean by "ranges transformed to structured tables?"
In the "By Position" tab, I used tables. The stuff in Sheet2 was an attempt to not use tables.
I don't see a "By Position" tab. I looked at the tab called "Sheet2". That's where I found your XLOOKUP formula. Am I missing something?
