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?
Answers
-
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))
-
Newbie question, but how does it know to pull from a certain sheet?
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!