What formula should I use, and how?
I have many sheets that collect different data on production lots and one sheet that show the most important data sets from those sheets. All the lots have an ID number that is used on all the sheets. I would like to look up that ID number from one sheet, copy a specific cell from that row, and return it to the main sheet in a specific cell in the row that matches the ID number. Would this be a LookUp formula, and if so how would I go about using it?
Example: One sheet shows the all aspects (look, smell, tase) of how we score the product and gives a final Grade. I want to grab the final grade only of a specific lot from the grading sheet and copy it to a Stock List in the associated row of the same ID number in a specific cell.
Best Answer
-
I would suggest an INDEX/MATCH.
=INDEX({Source Sheet Final Grade Column}, MATCH(ID@row, {Source Sheet ID Column}, 0))
Answers
-
I would suggest an INDEX/MATCH.
=INDEX({Source Sheet Final Grade Column}, MATCH(ID@row, {Source Sheet ID Column}, 0))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!