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!
Answers
-
Hi @Sarah12345 - You'll need a cross-sheet formula.
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?
Amber Eakin, MSLS, M.Ed.
Adult Education Specialist | Process Improvement Enthusiast
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!