Vlookup Function from Right to Left


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.




Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!