How to link specific fields from one sheet to another sheet?

Sheet #1 has two Columns, let's say they are titled "Name" and "Fruit". Under "Name", is a list of names i.e. Mitch, Sarah, Elizabeth, Pete etc. Under "Fruit" says apple, orange, kiwi, etc. I want to create a new sheet (Sheet #2) that could reference Sheet #1. For instance, if column "Fruit" in the first sheet says "Orange", then that person's name in Column "Name", will appear in let's say "Column A" of Sheet #2.

How would I set this formula up to make this happen?

Thanks for the help!

Find more posts tagged with

Formulas

Cell linking

Accepted answers

All comments

Amber Eakin

Hi @Sarah12345 - You'll need a cross-sheet formula.

https://help.smartsheet.com/learning-track/level-3-advanced-users/cross-sheet-formulas

It sounds like you'd need a VLOOKUP for this instance. It might look like this.

=VLOOKUP("Fruit@row", {REFERENCE SHEET RANGE including Fruit and Name columns}, 2, false)

Does that help?

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