nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Based on Value in Column A, do a lookup to a different sheet

Sharee Brell

So I have Sheet 1 = List of locations. In it I have various values, ID, Name, Address, City, State, Zip, Country, Phone.

Example: ID= 001 Name= Chicago Naperville

In Sheet 2 = Incident Reporting. In this sheet, I have a dropdown list that pulls the ID value from Shee1 List of Locations. The sheet has a form where the user selects from the drop down list a value. This is Column A. Example: Column A = 001

In Sheet 2, Incident Reporting, column B is entitled Name. I want to autofill this column the address associated with what is in column A from Sheet 1 Name.

Example: User enters 001 in the form. The Address is auto filled with Chicago Naperville.

Find more posts tagged with

Accepted answers

darkmatter

hey @Sharee Brell

I would suggest the Index Match function, explained here:

https://help.smartsheet.com/function/index

In addition, here's a great post from @Brett Wyrick on this subject.

https://community.smartsheet.com/discussion/84774/index-and-match-across-two-sheets-a-detailed-explanation

Let me know if you run into any issues.

Matt

All comments

darkmatter

hey @Sharee Brell

I would suggest the Index Match function, explained here:

https://help.smartsheet.com/function/index

In addition, here's a great post from @Brett Wyrick on this subject.

https://community.smartsheet.com/discussion/84774/index-and-match-across-two-sheets-a-detailed-explanation

Let me know if you run into any issues.

Matt

Sharee Brell

Thank you @darkmatter - it worked like a charm (once I got the syntax correct). I really appreciate your help!

darkmatter

Great to hear!

Sharee Brell

I then converted it to a column formula and the function is hugely helpful. Again, I appreciate your assistance!!

Andrée Starå

https://community.smartsheet.com/discussion/146869/based-on-value-in-column-a-do-a-lookup-to-a-different-sheet

Hi,

I hope you're well and safe!

To add to Matt's excellent advice/answer.

Another option could be the Column Link feature?

https://help.smartsheet.com/articles/2483493-create-column-links

Would that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Smartsheet Expert Consultant & Partner / CEO @ WORK BOLD

✅ Did my comment/answer help? Please support with 💡 ⬆️ ❤️ ✅ so others find it. Thank you! 🙏

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.