VLookUp

2 Tables

• Master Table
  • Needs Information
  • Must be on Left
• Reference Table
  • Has Information
  • Must be on Right
  • Should be Named
  • The 🔑 here is to make sure the common field that links to the master table to the Reference Table is to the left of the value being looked up. (Notice how Names preceeds Favorite Candy in the Reference Table)

Table that needs information

Name	Birthday	Color	Twitter	FavoriteCandy
Chris	1966-03-27	Red	@ChristineIyer	Look Up
Oliver	2001-01-21	Orange	@edithbirdd	Look Up
Edith	1998-03-22	Yellow	@MrNobody	Look Up
Leah	1970-10-03	Green	@sunnymede1	Look Up
Oscar	2004-02-16	Blue	@oskrrtmcnally	Look Up
Raizel	2001-05-31	Indigo	@MsNobody	Look Up

Table where missing info can be found

Names	FavoriteCandy	Number
Raizel	Look Up	1
Edith	Look Up	2
Leah	Look Up	3
Oliver	Look Up	4
Chris	Look Up	5
Paul	Look Up	6
Lolo	Look Up	7
Oscar	Look Up	8
Phoebe	Look Up	9
Jake	Look Up	10
Andrey	Look Up	11
Danika	Look Up	12

=VLOOKUP(A2, Name of Reference Table, Column Number of Reference Table that has the Missing Information, FALSE)