Spreadsheet: 697514d1601390011-v-lookup-noob-question-vlookup-example-julian
Sheet: export

Infusionsoft ID | First name | last name
473994 | [NAME] | Walsh
466882 | [NAME] | [NAME]
519429 | Adam | Hicks
458016 | Afi | Harrington
519363 | Aisha & Matt | [NAME]
423177 | [NAME] | [NAME]
381134 | [NAME] | Rodriguez
321816 | [NAME] | [NAME]
453442 | Alexandra | Lopez
381482 | [NAME] | [NAME]
575729 | [NAME] | McCoy
381374 | [NAME] | Osborn
430924 | Allysyn | Overton
317118 | Alvin | [NAME]
410401 | ALYSIA | WOLFSKEIL
439210 | Amanda | Batsche
472918 | Amanda | [NAME]
474754 | Amanda | Tarpening
482564 | Amanda | [NAME]
573843 | Amanda | [NAME]
494969 | Amber | Saunders
553987 | Amber | Manning
576085 | Amber | Manning
378626 | [NAME] | [NAME]
387073 | [NAME] | [NAME]
413847 | [NAME] | Blank
430506 | [NAME] | Jones
501685 | [NAME] | Jenkins
580169 | [NAME] | June
478932 | [NAME] | Fainberg
467772 | [NAME] | Castillo
412355 | [NAME] | Younkins
458832 | [NAME] | Martz
492317 | [NAME] | Thomaides
358113 | [NAME] | Madrid
316462 | [NAME] | Hermosillo
480678 | Angie | [NAME]
360297 | Anna | [NAME]
379687 | AnnMichelle | Hart
316246 | [NAME] | Carducci
518093 | Ariane | Sims
504435 | [NAME] | Radack Krassner
553255 | [NAME] | Radack Krassner
369421 | Artie | Pennington
423515 | [NAME] | Newman
467084 | [NAME] | Sharek
468852 | [NAME] | Bates
492961 | [NAME] | [NAME]
566347 | [NAME] | Dotchin
574361 | [NAME] | [NAME]
461694 | [NAME] | Mocek
437172 | [NAME] | Crimmins
565627 | [NAME] | Zweibel
504943 | Beatrice | Phan
413773 | [NAME] | Diederich
482618 | [NAME] | Kinney
475710 | Bethany | Gilson
436898 | Beverly | Davidek
363601 | [NAME] | [NAME]
565633 | Bina | [NAME]
319468 | [NAME] | Meynardie
366467 | [NAME] | [NAME]
444324 | [NAME] | [NAME]
385701 | [NAME] | [NAME]
322394 | [NAME] | [NAME]
419395 | [NAME] | Lonardo
451648 | Brana | [NAME]
424491 | [NAME] | Martin
431308 | Brejette | Bundy-Ford
462864 | [NAME] | Bates
572077 | Brent | Stamps
428402 | Bret | [NAME]
310828 | [NAME] | Mahoney
365615 | [NAME] | Ton
517489 | [NAME] | Musell
442286 | Bridget | Purvis
446340 | [NAME] | Hiatt
470268 | [NAME] | Laverty
361421 | [NAME] | Fagan
520419 | Camryn | Chase
484206 | Candice | [NAME]
510385 | Carina | [NAME]
420915 | Carly | Karpovage
441716 | Carly | Karpovage
413845 | [NAME] | Lasar
420497 | [NAME] | Dale
503679 | [NAME] | [NAME]
324954 | Carrie | Quraishi
516011 | Carrie | Norton
565637 | Carrie | Clarke
439814 | [NAME] | Conklin
468630 | [NAME] | Schwartz
467483 | Charlene | Usher
565731 | Charlene | Parker
391097 | [NAME] | Bishota
494797 | [NAME] | Larson
523247 | Chastity | Harville
564553 | [NAME] | [NAME]
340638 | [NAME] | [NAME]
432328 | [NAME] | Crago
434360 | [NAME] | [NAME]
554683 | [NAME] | [NAME]
577463 | [NAME] | Towery
310524 | Christine | Faulkner
459696 | Client Services | Concierge
491543 | Cory | Hughes
519751 | [NAME] | Junghandel
513827 | Cris | [NAME]
503077 | Crystal | Zellar
313736 | Dale | Bethel
519995 | [NAME] | Rieder
513171 | [NAME] | Weiner
522867 | [NAME] | Goodman
563057 | [NAME] | Campen
437472 | Danielle | Geye
566473 | Danielle | Riley
460390 | Darcy | [NAME]
322072 | Darlynn | Morgan
449220 | [NAME] | Levitt
310340 | [NAME] | Feakes
355285 | [NAME] | Bernstein
451984 | [NAME] | Calkins
454586 | [NAME] | [NAME]
465266 | [NAME] | Crawford
554755 | [NAME] | Talley
574359 | [NAME] | Kaufman
575609 | [NAME] | [NAME]
506525 | Dawn | Pigoni
457134 | [NAME] | [NAME]
565767 | Deb | Bilbao
417605 | Debbie | Turner
416489 | [NAME] | [NAME]
440620 | [NAME] | [NAME]
362657 | [NAME] | [NAME]
438776 | [NAME] | [NAME]
491015 | [NAME] | Barbee
458932 | [NAME] | O'Donnell
378079 | [NAME] | Gosnell
406197 | [NAME] | Haney
430706 | [NAME] | Rendon
516069 | [NAME] | Sulea
420997 | [NAME] | Kilcoyne
445682 | Dilenia | Frias
452210 | Dinamary | Horvath
398671 | [NAME] | [NAME]
513303 | [NAME] | [NAME]
570665 | [NAME] | Bolsover
462560 | [NAME] | Cassella
415691 | Edna | Wenning
427442 | Eileen | Maastricht
326136 | Elena | [NAME]
366657 | Elinor | Smith
323806 | [NAME] | [NAME]
326164 | [NAME] | [NAME]
370213 | [NAME] | Mehling
516405 | [NAME] | Smith
462992 | Ellie
581479 | [NAME] | [NAME]
469018 | [NAME] | Scheele
514877 | [NAME] | Beutel
551403 | [NAME] | Scheele
507939 | [NAME] | Endyke
320208 | Erich | Niederlehner
443302 | Erin | [NAME]
Id | First Name | Last Name
376225 | Geoff | Hoatson
310350 | [NAME] | [NAME]
440622 | Gerri | [NAME]
313274 | Gloria | Petroni
417603 | Greg | Vanevenhoven
500469 | Greg | Gordillo
577465 | Gretchen | Lehman
481684 | [NAME] | [NAME]
427590 | [NAME] | Amra
522117 | Harlan | Mitchell
410759 | Hayley | [NAME]
411591 | Heather | [NAME]
432442 | Heather | Pietroforte
566061 | Hector | [NAME]
431938 | [NAME] | Blank
370581 | Ian | [NAME]
444020 | [NAME] and Hector | [NAME]
521989 | [NAME] | Fischer
477554 | Itzi | [NAME]
312690 | [NAME] | Doggette
569559 | [NAME] | Bard
371221 | Jaime | Rocha
310322 | [NAME] | McMahon
416567 | [NAME] | Cote
518503 | [NAME] | Long
415379 | [NAME] | Marcario
314070 | [NAME] | [NAME]
357865 | [NAME] | [NAME]
389583 | Jayme | Fisher
383867 | [NAME] | Field
311324 | [NAME] | Lerman
379002 | [NAME] | Manley
472558 | [NAME] | Lally
553597 | [NAME] | [NAME]
344710 | [NAME] | [NAME]
381164 | [NAME] | Heisinger
427886 | [NAME] | Goldston
503523 | [NAME] | [NAME]
518057 | [NAME] | [NAME]
565679 | [NAME] | [NAME]
463328 | [NAME]
396715 | [NAME] | Patton
459792 | Jessica | Séguin
462572 | Jessica | Jorns
467246 | Jessica | Toledano
473424 | Jessica | [NAME]
565623 | Jessica | [NAME]
395459 | [NAME] | Magnani
392779 | Jiah | [NAME]
572107 | [NAME] | [NAME]
565671 | Jodi | Hinkle
478334 | [NAME] | [NAME]
477976 | Joel | Norris
357345 | [NAME] | Kokolakis
423291 | [NAME] | Rommel
428558 | [NAME] | Hilton
459498 | [NAME] | [NAME]
565713 | [NAME] | Gies
467568 | Jordan | [NAME]
443398 | [NAME] | [NAME]
395359 | [NAME] | Nepowada
482010 | [NAME]
363623 | [NAME] | Driskell
396515 | [NAME] | Booker
315842 | [NAME] | [NAME]
395951 | Julia | [NAME]
438926 | Julie | Noe
575727 | Julie | [NAME]
359737 | Jumoke | [NAME]
444896 | Justin | Jenkins
447914 | [NAME] | [NAME]
563131 | [NAME] | Becker
471082 | Kat | Boushee
464418 | Katheryne | [NAME]
389655 | Kathy | Palmquist
469682 | [NAME] | Treece
565625 | [NAME] | Helber
521713 | [NAME] | Deen
363769 | [NAME] | Kozura
396237 | [NAME] | [NAME]
322062 | Kelly | Mason
420063 | Kelly | [NAME]
450256 | Kelly | [NAME]
466702 | Kelly | Fortin
580955 | Kelly | Balamuth
403909 | Kelsey | Quaranto
465708 | Kendra & Michelle | O'Toole and Reed
420675 | Kent | [NAME]
511897 | [NAME] | [NAME]
361365 | [NAME] | Stratton
317866 | [NAME] | [NAME]
400525 | [NAME] | [NAME]
468382 | [NAME] | Murch
565619 | [NAME] | Natapow
391965 | [NAME] | Rockwood
563783 | [NAME] | Life
473230 | Kimbretta | Clay
360289 | Kiran | Meettook
518485 | Klea | [NAME]
410719 | Kris | Benavidez
432330 | Kristen | Boone
456810 | Kristen | [NAME]
503293 | [NAME] | Wells
564733 | Kristy | Goldman
580145 | [NAME] | Hildebrandt
477552 | L'Amour | [NAME]
447674 | [NAME] | Croft
565501 | Lauren | Ridgley
310962 | [NAME] | Rouse
450024 | Leigh | Goodson
368515 | [NAME] | Marenco
470528 | [NAME] | Sparks
361977 | Lester | [NAME]
522093 | Leticia | DeSuze
430584 | [NAME] | [NAME]
424313 | [NAME] | [NAME]
474996 | [NAME] | Chrisler
459198 | Lindsey | Walker
438750 | [NAME] | Schwartz
520053 | [NAME] | Sutton
462688 | [NAME] | Coultrip
414341 | [NAME] | Johns
499869 | Loucile | Powers
429958 | LuAnne | Hage
572029 | LuAnne | MacantaTransition
572031 | LuAnne | MacantaTransition
411195 | [NAME] | [NAME]
473750 | [NAME]
413891 | Mackenzie | Sorich
426022 | Mackenzie | [NAME]
464760 | Maiybelle
455384 | Mallory | [NAME]
465352 | [NAME] | Bullock
316488 | [NAME] | [NAME]
513073 | [NAME] | Pinney
408977 | Maribel | Ellington
388941 | [NAME] | Maloy
454682 | Marjorie | [NAME]
315562 | Mark | Petersen
386627 | Mark | Torok
445878 | Mark | Sowers
365367 | [NAME] | Mundheim
447992 | [NAME] | Tauber
491043 | [NAME] | Yancey
469414 | [NAME]
359599 | [NAME] | Wasigner
394041 | [NAME] | Meuli
398511 | [NAME] | Tranter
577447 | [NAME] | Beese
426024 | [NAME] | Kimball
477054 | [NAME] | Tramm
434056 | [NAME] | Adler
480824 | Meagan | Agne
315556 | Meg | Obenauf
452380 | [NAME] | Stokes
395759 | [NAME] | Pittman
553965 | [NAME] | Pittman
572019 | [NAME] | MacantaTransition
572023 | [NAME] | MacantaTransition
417367 | [NAME] | [NAME]
462994 | [NAME]
458386 | Member | Concierge
510317 | Merlaine | [NAME]
448050 | Micah | Coker
563349 | Micah | Coker
361711 | [NAME] | Hernton
365231 | [NAME] | [NAME]
370171 | [NAME] | Sellers
404325 | [NAME] | [NAME]
417531 | [NAME] | [NAME]
440086 | [NAME] | Sweeney
496335 | [NAME] | McDonald
310458 | Michelle | Mahieu
310700 | Michelle | [NAME]
318294 | Michelle | [NAME]
322330 | Michelle | [NAME]
566955 | Michelle | Salater
365307 | [NAME] | [NAME]
577445 | [NAME] | Breeze
519567 | Milan | Hanson
372489 | Milo | [NAME]
408479 | Molly | [NAME]
569669 | [NAME] | DiCesare
361687 | Myrna | Arroyo
437678 | Myrna | [NAME]
502553 | Naja | Hawk
502801 | [NAME] | [NAME]
567215 | [NAME] | Hermansen
420395 | Naomi | [NAME]
522173 | Nara | Callanan
418801 | Natalia | Bevilacqua
410497 | [NAME] | Giachos
457098 | [NAME] | Ward
468218 | [NAME] | [NAME]
466604 | Natalya | Evans
378183 | Nathan | Croxford
434084 | [NAME] | Ray
570523 | [NAME] | Thompson
419477 | Nell | Pretzsch
520203 | Nick | Leydorf
577453 | Nick | [NAME]
310354 | Nicole | Newman
444248 | Nicole | Qu
484826 | Nicole | Martins
499691 | Nicole | Connors
507887 | Nicole | [NAME]
507171 | Nikki | [NAME]
474132 | Nina | Butrim
320532 | Nirosha | Ruwan
490795 | [NAME] | [NAME]
494367 | Oleg | [NAME]
457104 | Olivia | [NAME]
468820 | Paige | Sciba
519065 | Pam | Girardi
572377 | Pam | Flores
399973 | [NAME] | Maass
420761 | Pantea | Fozouni
452362 | [NAME] | Martin
522667 | Paulette | [NAME]
381750 | Polly | Tatum
463260 | Previn | Wick
565775 | Rachel | [NAME]
427720 | Rachell | Long
416863 | [NAME] | Stocks
402353 | Randi | [NAME]
575715 | Ray | Cue
313418 | Rebecca | Strub
564699 | Rebecca | Easton
565819 | Rebecca | Elswit
582303 | Rebecca | Strub
370723 | Regina | Ratner
430006 | Rich | Golze
456670 | Rich | [NAME]
448322 | [NAME] | Vaught
482336 | [NAME] | [NAME]
519263 | [NAME] | Forsythe
478348 | Robyn
420333 | Rohany | Karya
441886 | Roland | Soltesz
315712 | [NAME] | Soto
404732 | Rosane | Pires
443594 | Rosane | Pires
475088 | Rose | Coonen
472248 | [NAME] | [NAME]
521657 | [NAME] | Horn
378256 | [NAME] | [NAME]
368453 | Rozita | Yacobi
463312 | Rubi | Burke
438564 | [NAME] | [NAME]
415819 | Sahmra | Stevenson
519653 | [NAME] | [NAME]
565911 | Samantha | [NAME]
422439 | Sandra | Greene
479184 | Sandra & Jean Marie | Assistants
436402 | Sara | Walter
448066 | [NAME] | Horowitz
462502 | [NAME] | Nowles
471098 | [NAME] | [NAME]
471570 | [NAME] | Breiner
332584 | Scott | [NAME]
393465 | Scott | Shoemaker
415267 | Scott | [NAME]
444512 | Scott | Lynch
461220 | Scott | [NAME]
498641 | Scott | Sweitzer
439124 | Sean | [NAME]
389033 | Shaakira | Gold-Ramirez
520925 | Shaina | Jones
552195 | Shalini | [NAME]
480190 | Shane | [NAME]
465686 | Shane Jasmine | Young
482204 | Shane Young | CSD
447264 | Shari | [NAME]
425736 | [NAME] | Green
520761 | [NAME] | Winn
468686 | [NAME] | [NAME]
380590 | Shelly | [NAME]
577457 | [NAME] | Long
421401 | Sheryl | Keeme
491949 | Shihlan | [NAME]
570143 | Shirin | [NAME]
477418 | Sivonnia | DeBarros
576057 | Sofia | Henshaw
476794 | [NAME] | Chaffin
517421 | [NAME] | Palmer
367563 | Stacie | Zimmerman
357461 | [NAME] | Scarborough
484498 | [NAME] | Kitzes
569197 | [NAME] | Hon
566457 | Stephen | [NAME]
392957 | [NAME] | Hollatz
410519 | [NAME] | Navidad
311208 | [NAME] | Law Group
363971 | [NAME] | Boss
370631 | Stuart | [NAME]
394013 | Sue | [NAME]
419091 | Suren | Adams
372681 | [NAME] | Bratcher
317488 | [NAME] | Hamwi
459164 | Susanna | Maida
388709 | Suzan | Colgan
555051 | Suzan | Pruter
382942 | Tamara | Mccormic
439240 | [NAME] | Rivera
575395 | [NAME] | Silvas
419865 | Tanya | [NAME]
359297 | Tara | Wilson
446154 | Tara | Cheever
491947 | [NAME] | [NAME]
504157 | [NAME] | Haley
482820 | Theodore | Tehrani
418325 | [NAME] | Whitney
475398 | Tiffani | [NAME]
310642 | [NAME] | Cleary
315776 | [NAME] | MacArthur
396005 | [NAME] | [NAME]
388991 | Timothy | McCan
520683 | [NAME] | [NAME]
440484 | TJ | Scott
406953 | Todd | Rosenfield
460676 | Todd | [NAME]
568343 | [NAME] | [NAME]
507387 | Tonya | Sayers
310380 | [NAME] | Ingle
481292 | Trevor | Stevenson
567101 | Trish | Butcher
431508 | Tyler | Dahl
445570 | Va | [NAME]
455126 | Vani | Moodley
481302 | Viviana | Oropeza
429602 | Wade | [NAME]
364495 | Wally | [NAME]
425700 | [NAME] | Pech
485232 | Will | Stafford
445966 | [NAME] | Burns
440450 | Yaasha | Sabba
477898 | [NAME] | [NAME]
430866 | Yasmine | Salem [NAME]
489639 | Yendi | Castillo
452230 | Yesenia | Thompson
406385 | Yodel | Penacho
409807 | Zhemin | Shen