How to import data from other sheets?

Hey all. So I am looking to set up 2 sheets for inventory tracking. The first sheet will be a 'database' of SKUs along with item manufacturer names, model numbers, SKUs etc.

I want to use that database sheet to feed my inventory tracking sheet. Ideally what I'd like to set up is:

Item Sheet: select SKU-001

Sheet references database for SKU-001, and fills in the Manufacturer, Item Name, Model #, Item Category, etc.

How would I go about achieving this?

Find more posts tagged with

Formulas

Automations

Cell linking

Accepted answers

All comments

Paul Newcome

You would use an INDEX/MATCH for each of the different data points you want to pull in.

=INDEX({Range You Want To Pull}, MATCH(SKU@row, {SKU Column}, 0))

Mycelus

https://community.smartsheet.com/discussion/comment/333019#Comment_333019

Newbie question, but how does it know to pull from a certain sheet?

Paul Newcome

When typing out your formula

=INDEX(

there should be a little helper box that pops up. In that box is a link to "Reference Another Sheet". Click on that link, select the appropriate sheet, select the appropriate range from the sheet (click on column header to select full column), optionally but highly suggested rename the range in the top left, then click on the blue button in the bottom right to "Insert Reference".

It should bring you back to the formula but should now look like this

=INDEX({Name Of Cross Sheet Reference}

From there you keep on typing out the formula creating any additional cross sheet references as needed in the same way.

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.