How do make index Match or VLookup grab the latest value

[Bing2505]

Hi there everyone, I have a question regarding these functions mentioned above. I have a worksheet, which i cant show for confidentiality purposes, but i have illustrated my problem below. I am looking for a function using either Vlookup or Index Match, preferably the latter. My issue is, i have a lot of columns with recurring numbers, but i only want to select and save the latest outcome. So in the example, how do i make either of the functions grab the number 3 instead of the number 1? Any help would be greatly appreciated. Thanks everyone

[#2 · Accepted solution]

@Bing2505 

If you have Microsoft 365 or Office 2021 (or use Excel Online), you can use XLOOKUP:

If you have an older version, you can use an array formula confirmed by pressing Ctrl+Shift+Enter:

[#3]

Hello Hans, thank you so much for your help. You helped me resolve the problem that I spent the longest time trying to resolve. Really appreciate your time, have a great week and take care!