How to Do a VLOOKUP With Two Spreadsheets in Excel

Video quality	The size	Download

Information How to Do a VLOOKUP With Two Spreadsheets in Excel

Title	:	How to Do a VLOOKUP With Two Spreadsheets in Excel
Lasting	:	1.14
Date of publication	:
Views	:	1 jt

thank you for sharing you made it so easy to understand
Comment from : Salman Rashid

Absolutely amazing
Comment from : Daisi Funmilola

Volume is too low to hear you well enough in your video
Comment from : Wade Russell

this didn't teach me how to look anything up unless it is on the one single sheet you had it search How do I get it to search through ALL of those worksheets you have down at the bottom?
Comment from : taller3

Best video out there, followed concept for mine and worked like a treat Thanks
Comment from : wayne9394

Shit
Comment from : Nikhil V

Important note! When you have a spreadsheet with a lot of columns: just make sure that the column with the lookup value is simply left of the column you want to search in The Vlookup function can only search to the right!
Comment from : Excel Essentials

Thank you, explained in the easiest manner
Comment from : Sohail Ansari

Thank you for this concise video
Comment from : Adonis Aondoakula Udele

This is so good easy thank you
Comment from : josephine leiyan

I noticed that the first data is always the furthest left column Is that standard? I'm trying to find matching form data (by name not number) on two different worksheets However the form name is column C Can I use VLookup still?
Comment from : Karina Simon

hard to hear
Comment from : William Fontaine de la Tour Dauterive

Thanks for the video But can it also return the entire column?
Comment from : MAGNUS OFOEZE

The simplest and most efficient way I have ever been taught to do that You are awesome!!! Thank you
Comment from : NAKAMANYA ALEX GLORIA

would be easier if the found values were also visible and easier Instead of GUID numbers
Comment from : Vinodh D D

you saved my life
Comment from : Daniel Kostov

Thanks Short and sweet
Comment from : Russell Sirianni

He didn't explain that well He explained it to someone that knows how to do a vlookup For someone that doesn't know, that brings on several questions
Comment from : Mister Toneconsultant

Never thought I would be learning about vlookups from Sir Scott Dissick lol
Comment from : Kellee Hubbard

Although super short, this has been the answer for me Thank you
Comment from : Marcos Moreno

HI I need help from you for my office work with excel
Comment from : universal inlanka

This is by far the best example of vlookup demonstrated Keep it up!
Comment from : Rizwan Nazir

Brilliant - thank you!
Comment from : Dharmesh Bharadva

Nailed it!! Thank you so much for posting I struggle so much with this formula 🙈
Comment from : Nesha

Thanks, that was quick and helpful👍🏻
Comment from : Reshma Honrao

I like the time frame of your explanation 😊
Comment from : Shawn Ahmad

Best one on vlookup
Comment from : Homo-Sapien

And people are out there making 2 hours videos on vlookup lmao
Comment from : Akshay Balaji

I learned more from this 1 minute video than I did with some of those 10 minute ones Thanks!
Comment from : Everyones Invited

Absolute legend, I was stuck on this for well over half an hour doing my uni work, the lecturer put it in the instructions but didn’t actually show us how to do it
Comment from : Connor Dennis

i have watched a million videos trying to figure out vlookups and watched your video once and immediately understood what i was doing thank you so much
Comment from : Thisbishsaysss

Very nice video no time wasting for like & subscribe thank bro lot's of love from India
Comment from : Jyoti Paswan

Thanks!
Comment from : DJ Marco Larese

Volume is too low; I can't even hear you
Comment from : Wade Russell

I am a very simple person and I get confused when people over explain Thanks for this very simple video 😊
Comment from : Jadean P

Bless
Comment from : clark oddy

Thanks!
Comment from : ClassicRockProtein

Hands down, this is the best, easiest avido e i found that works I wish I’d found it sooner!
Comment from : Carola

Thanks
Comment from : Koem Borana

Very interesting Video! I guess I was a Vlookup user for a long time, but I just discovered a new XLOOKUP function in Excel for Office 365 that addresses a lot of the shortcomings: left lookup, not found error, Search from bottom to top If Interested: youtube/0Abkk12WCmk
Comment from : sabrina Jones

might want to finish that off with a ,FALSE) otherwise you won't get exact matches only
Comment from : Gavin McGerald

Thank you so much for the video super quick, easy to follow and yielded beautiful results from a novice
Comment from : Brittany K

Straight to the point tks
Comment from : Kunta

Very helpful and clear instructions Thanks
Comment from : Azam Ali

Thank you soooo much you really helped me with something I been stumped on for 2 days 😃
Comment from : A New

You sir are a life saver!!!
Comment from : JR

Very simple Thank You
Comment from : Aloka

No it's not that was data from one spreadsheet
Comment from : ana lopez

Thanks a mil mate!
Comment from : Dani Botan

😂😂😂😂😭 this is me
Comment from : MaaliRK_Universe

Thank you for saving my life
Comment from : Michael Quiles

Thank you so much for just getting straight to the point - very helpful
Comment from : Leaha F

Quick and to the point ! Thanks King
Comment from : Thabang Oliphant

Thanks a lot!!!!!!
Comment from : Paola C Fitness

Question : can the vlookup retrieve data from the pivot table or does it have to be from the original data table ?
Comment from : Shanai

Holly sh*** the man is a Genius straight to the point
Comment from : Varci Horacio

Thank you very much, this video really helped!
Comment from : Great Day

Nail on the head Thank you
Comment from : P J

quick and simple saved me hours
Comment from : Adam Kimsey

super easy to follow so glad i found your video would have saved me MANY hours of manual work had I ever heard of vlookup before, AND, would have saved me hours of searching for an understandable video had I found YOURS first!! I'm a bit hard of hearing and really had to crank my volume up to hear you might just be me just saying new sub and like! thanks
Comment from : Jason Starr

AMAZING Better than other videos out there Quick and easy instruction
Comment from : Riraki

Straight to the point Succinctly explained Liked and subscribed without hesitation GOD bless you richly
Comment from : Brighton Mutongwizo

My guy 👊
Comment from : Rafiu Ahmed

Jesus christ, thank you! I've watched all of these other folks with 15 minute videos and still dont understand Thank you for this short and simple video
Comment from : Billy N

Thanks bud You explain things very simply without all the bla bla
Comment from : Iren

Thank You!
Comment from : Dusti Young

Very helpful, very concise, 10/10 mate!!
Comment from : OrionOmegus

Okay, you made this waaaaay to easy, and I LOVE it!! Thank you so much :-)
Comment from : Spud E Buddy

Instructions nice and simple, just like mebrbrThanks for the help
Comment from : Paul Nipper

I tried this method multiple times and it didn't work WHen I pressed enter, it gave the wrong data back
Comment from : Cassandra Persaud

I literally watched 6 videos before yours and none of them made any sense and were sooo long I haven't done much excel work in 2020 (thanks COVID!) so I really needed a refresher Thanks for keeping this short and sweet!!
Comment from : cam

Absolute hero thx
Comment from : Mark Pracy

youtube/a9kKxEZGCGkbrbI advice to subscribe to this guy/b
Comment from : Victor Victor

awesome explanation of something I used to do daily and needed a refresher! thanks alot
Comment from : Lucy Smith

No bullshit, just point to point explanation
Comment from : Gurpreet Singh

Excellent explanation It worked the first time Thank you
Comment from : Stacey Grant

I'm following your example exactly but i keep keeting #N/A - currently at my work desk
Comment from : Edward Cook

Thank you!!
Comment from : Sunil Kumar

In the bathroom at a job looking this up now because I said I've done v lookups before
Comment from : tidey4

you have skip if the data is approximately(TRUE) OR exact(FALSE) , that formula will not be much accurate
Comment from : Mark John Catubuan

THANKS!!!!! YOU SAVED ME SO MUCH TIME 👏🏾👏🏾👏🏾
Comment from : Jessica Young

thank you very much Helps me a lot
Comment from : Aswin Shankar

bless you, i tried like six different times before finding your video, it's finally working
Comment from : Diana Heard

Thank you for the very simple smart clarification
Comment from : Maisa Mohamed

Thank you for getting right to the point I hate how all these other video give a history lesson of VLOOKUP before getting to the point
Comment from : Gustave