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

Find more posts tagged with

Accepted answers

All comments

Therese Murphy -DPSCS-

Just to correct...in my actual lookup table FULLNAME is the primary column and Acronym is Column2

Therese Murphy -DPSCS-

The above notes is my own correction

Bassam Khalil

Hi @Therese Murphy -DPSCS-

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.

Therese Murphy -DPSCS-

Thank you so much...what would the VLOOKUP formula look like if you were referencing another sheet?

Bassam Khalil

Hi @Therese Murphy -DPSCS-

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!

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.