Spreadsheet: 697508d1601388438-v-lookup-noob-question-vlookup-example
Sheet: Sheet1

Infusionsoft ID | first name | last name
 | [NAME] | Walsh
 | Adam | Hicks
 | Aisha | [NAME]
 | [NAME] | Rodriguez
 | [NAME] | [NAME]
 | Amanda | Batsche
 | Amanda | [NAME]
 | Amber | Saunders
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Jenkins
 | [NAME] | June
 | [NAME] | Fainberg
 | [NAME] | Castillo
 | [NAME] | [NAME]
 | Ariane | Sims
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Sharek
 | Beatrice | Phan
 | Bethany | [NAME]
 | Beverly | Davidek
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | Brana | [NAME]
 | [NAME] | Bates
 | Brent | Stamps
 | Brett | [NAME]
 | [NAME] | Musell
 | [NAME] | Ton
 | [NAME] | Laverty
 | Camryn | Chase
 | Candice | [NAME]
 | Carina | [NAME]
 | [NAME] | Dale
 | Carrie | Quaraishi
 | [NAME] | Conklin
 | [NAME] | Schwartz
 | Charlene | Usher
 | [NAME] | Bishota
 | [NAME] | Larson
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | Christine | Faulkner
 | Cory | Hughes
 | Cris | [NAME]
 | Crystal | Zellar
 | [NAME] | Rieder
 | [NAME] | O'Donnell
 | [NAME] | Campen
 | [NAME] | Goodman
 | [NAME] | Weiner
 | Danielle | Riley
 | Danielle | Geye
 | Darlynn | Morgan
 | [NAME] | Levitt
 | [NAME] | Bernstein
 | [NAME] | Feakes
 | [NAME] | Kaufman
 | [NAME] | [NAME]
 | [NAME] | Talley
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | Soto
 | [NAME] | O'Donnell
 | Delania | Barbee
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | Doug | Bolsover
 | Eileen | Maastricht
 | Elena | [NAME]
 | [NAME] | Mehling
 | [NAME] | Smith
 | [NAME] | Smith
 | [NAME] | Beutel
 | [NAME] | Endyke
 | Erin | [NAME]
 | Geoff | Hoaston
 | [NAME] | [NAME]
 | Gloria | Petroni
 | Greg | Gordillo
 | Gwendoyln | Braswell
 | Haley | Simmoneau
 | [NAME] | Amra
 | Harlan | Mitchelll
 | Heather | Pietroforte
 | Hector | [NAME]
 | Ian | [NAME]
 | [NAME] | DeJesus
 | [NAME] | Doggette
 | [NAME] | Barde
 | Jaime | Rocha
 | [NAME] | Long
 | [NAME] | [NAME]
 | Jayme | Fisher
 | [NAME] | Lally
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | Jessica | Magnani
 | Jessica | Toledano
 | [NAME] | [NAME]
 | [NAME] | Gregory
 | [NAME] | [NAME]
 | Joel | Norris
 | [NAME] | [NAME]
 | [NAME] | Hilton
 | [NAME] | Kokolakis
 | [NAME] | Rommel
 | Jordan | [NAME]
 | Juan | Pyfrom
 | Julia | [NAME]
 | Jumoke | [NAME]
 | [NAME] | Deen
 | Kelly | [NAME]
 | Kelsey | Quaranto
 | [NAME] | O'Toole
 | [NAME] | [NAME]
 | [NAME] | Life
 | [NAME] | Rockwood
 | Klea | [NAME]
 | Kristen | Boone
 | Kristen | [NAME]
 | [NAME] | Wells
 | Kristy | Goldman
 | [NAME] | Hildebrandt
 | [NAME] | Croft
 | [NAME] | Marenco
 | [NAME] | Sparks
 | [NAME] | [NAME]
 | [NAME] | Sutton
 | [NAME] | Coultrip
 | [NAME] | Bullock
 | [NAME] | [NAME]
 | [NAME] | Pinney
 | Marjorie | [NAME]
 | Mark | Petersen
 | [NAME] | Mundheim
 | [NAME] | Yancey
 | [NAME] | Meuli
 | [NAME] | Tramm
 | [NAME] | Wasinger
 | [NAME] | Adler
 | Meagan | Agne
 | [NAME] | Stokes
 | Merlaine | [NAME]
 | [NAME] | McDonald
 | [NAME] | [NAME]
 | Milan | Hanson
 | Molly | [NAME]
 | Myrna | Arroyo
 | Naja | Hawk
 | [NAME] | Hermansen
 | Nara | Callanan
 | [NAME] | Giachos
 | [NAME] | [NAME]
 | Natalya | Evans
 | [NAME] | Thompson
 | Nick | Leydorf
 | Nicole | Connors
 | Nicole | Martins
 | Nicole | Newman
 | Nina | Butrim
 | [NAME] | [NAME]
 | Oleg | [NAME]
 | Olivia | [NAME]
 | [NAME] | Flores
 | [NAME] | Girardi
 | [NAME] | Maass
 | Pantea | Fozouni
 | [NAME] | Butcher
 | [NAME] | Martin
 | Paulette | [NAME]
 | Polly | Tatum
 | Previn | Wick
 | Rachell | Long
 | Randi | [NAME]
 | Rebecca | Easton
 | Rebecca | Strub
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | [NAME] | [NAME]
 | Rose | Coonen
 | [NAME] | Horn
 | [NAME] | [NAME]
 | Rozita | Yacobi
 | [NAME] | [NAME]
 | Samantha | [NAME]
 | Samhra | Stevenson
 | [NAME] | Breiner
 | [NAME] | Nowels
 | Scott | [NAME]
 | Scott | Shoemaker
 | Scott | Sweitzer
 | Sean | [NAME]
 | Shaina | Jones
 | Shaakira | Gold-Ramirez
 | Shalini | [NAME]
 | Shane | [NAME]
 | Shane | Young
 | [NAME] | Winn
 | [NAME] | [NAME]
 | Shelly | [NAME]
 | Shirin | [NAME]
 | Shihlan | [NAME]
 | [NAME] | Chaffin
 | [NAME] | Palmer
 | [NAME] | Hon
 | [NAME] | Kitzes
 | Stephen | [NAME]
 | [NAME] | Scarborough
 | [NAME] | Boss
 | Stuart | [NAME]
 | Suren | Adams
 | [NAME] | [NAME]
 | [NAME] | Pruter
 | [NAME] | Silvas
 | Tanya | [NAME]
 | Tara | Cheever
 | [NAME] | Haley
 | [NAME] | [NAME]
 | Tiffani | [NAME]
 | Timothy | Scott
 | [NAME] | [NAME]
 | Todd | [NAME]
 | Tonya | Sayers
 | Tyler | Dahl
 | [NAME] | Terzian
 | Vani | Moodley
 | [NAME] | Pech
 | [NAME] | Burns
 | Will | Stafford
 | Yaasha | Sabba
 | [NAME] | [NAME]
 | Yendi | Castillo