Referencing a Lookup Table
Good afternoon,
I am rather new to Smartsheet formulas. I am trying to reference a lookup table column. Please see screenshot.
In the main table, I would like e.g. "MM" to autopopulate when Mickey Mouse is entered in the FULLNAME column.
Whether I try VLookup or Index/Match in the FULLNAME column of Main Table, I receive errors. I am sure that it is a simple fix.
Any assistance would be greatly appreciated. Thanks, Therese Murphy
Answers
-
Just to correct...in my actual lookup table FULLNAME is the primary column and Acronym is Column2
-
The above notes is my own correction
-
Hope you are fine, i prepared a sample sheet for your question and i hope the following will solve it.
1- Acronym column & FULL NAME Column & Formula Column are Text / Number type.
2- Criteria Column is dropdown menu type contain all Acronym you will use.
3- in formula column use this formula =VLOOKUP(Criteria@row, Acronym:[FULL NAME], 2, 0) and convert it to column formula.
now when you select from Criteria column any Acronym automatically you will get the full name in formula column.
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
Thank you so much...what would the VLOOKUP formula look like if you were referencing another sheet?
-
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!
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!