How do I return Last Match with VLOOKUP

Hello,

My VLOOKUP function is always returning the first match other than the last match.

The lookup table is updated chronologically, and I need to return the most recent data which will always be the last match.

I'm open to other solutions that use other functions.

Thanks.

Find more posts tagged with

Sheets

Formulas

Support

Accepted answers

All comments

David Joyeuse

Hi @Brandon Tong

I'd suggest use using some MAX/COLLECT formula instead of VLOOKUP in your case.

Hope it helped!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.