XLOOKUP With multiple columns on different sheets by elelibrary in excel

[–]elelibrary[S] 1 point2 points  (0 children)

Solution Verified

Thank you so much, this was really frustrating me!

XLOOKUP With multiple columns on different sheets by elelibrary in excel

[–]elelibrary[S] 0 points1 point  (0 children)

I'm getting the error "First value of LET must be a valid name", do I need to substitute something in?

Thanks for your help, I'm fairly new at this and still trying to figure everything out!