Vlookup Function from Right to Left

Manzoor Mehaboob

Hello Everyone,

Can someone help to understand how I can do a Vlookup from Right to Left.

I am trying to add a unique ID to the right most column of two sheets and do a vlookup from Right to Left.

While exploring this topic, I found solution to do it using CHOOSE in EXCEL however bit tricky in SmartSheet.

Hope someone who knows will help me out here.

Regards,

Manzoor

Find more posts tagged with

Formulas

Accepted answers

Andrée Starå

Hi @Manzoor Mehaboob

You can add a so-called helper column with the ID closer to the columns, but it would need to be on the left of the range. Otherwise, you’d need to use a combination of INDEX/MATCH.

Would that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

All comments

Andrée Starå

Hi @Manzoor Mehaboob

You can add a so-called helper column with the ID closer to the columns, but it would need to be on the left of the range. Otherwise, you’d need to use a combination of INDEX/MATCH.

Would that work/help?

I hope that helps!

Have a fantastic week & Happy Holidays!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Manzoor Mehaboob

Hi Andree,

That was an easy fix using Index & Match. Thanks for helping

Regards,

Manzoor M

Andrée Starå

@Manzoor Mehaboob

Excellent!

You're more than welcome!

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.