Forum Discussion
Xlookup
Hi All, So I've got the following formula =XLOOKUP(C1,$K:$K,$L:$L,0) to check a name on one list and give me back a value that corresponds, the problem is that the names are formatted differentl...
Still cannot read the screenshot. I repeat:
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Alternatively, you can attach it to a private message to me. Thanks in advance.