Forum Discussion
Solved
How do make index Match or VLookup grab the latest value
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 looki...
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:
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:
- 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!
