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

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!

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!

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!