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

Sarah12345

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!

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?