Forum Discussion
Solved
XLOOK UP multiple criteria
Hello, In sheet 2, I want a formula in column B that picks for the latest year in column C of the Data 1 sheet, a value in column B for a code in Column A of sheet 2, based on criteria in Data 1 she...
Lycias The last optional argument is set to -1, which means that the search is done "last-to-first", so from the bottom up. Since your data is sorted in ascending year order, it works.
Riny_van_Eekelen Thank you so much, a lifesaver. I see that the formula is picking the latest value (Time, in column A of sheet 1) for each country code. Which part of this formula is achieving this? I can follow the rest of the solution except this part. Thank you.
Lycias The last optional argument is set to -1, which means that the search is done "last-to-first", so from the bottom up. Since your data is sorted in ascending year order, it works.
- Perfect, thank you so much!.