XLOOKUP but for multiple cells?

Unsolved

So I'm making a spreadsheet of movies. Columns A to D is the spreadsheet unsorted, while E to H is sorted according to a number value. Column A uses the XLOOKUP formula to look up the number in column E, which is the movie's position in the ranking, columns B and F are the movie's name, columns C and G are the year the movie was released, and columns D and H is the number value. However, there's a problem where there are movies with the same title but different release years, and when this happens XLOOKUP just gives me the value in column E next to whichever movie appears first in the list. How do I make a formula similar to XLOOKUP that takes into account both the title and the release year?

Posted Aug 31, 2025, 12:24 AM UTC

11
Loading comments…