Excel VLOOKUP With Multiple Workbooks

Video quality	The size	Download

Information Excel VLOOKUP With Multiple Workbooks

Title	:	Excel VLOOKUP With Multiple Workbooks
Lasting	:	12.14
Date of publication	:
Views	:	3,2 jt

You lost me
Comment from : Daniella Chedid

I know this was done a long time ago, but If you have the formula you created, and you drag the formula down, it changes the numbers that you are looking for to be off because it is trying to increase each set of numbers by one because of dragging it down You state you are looking at row 73, as an example, but I don't know what row it is in and I want it to search the entire array Other than going into the formula for each line and correcting the rows, how can you repeat the exact formula? I hope this makes sense
Comment from : Jade Cali

Thanks Jatan!brThis video is really enlightening I was able to complete my task by watching this video 🎉
Comment from : tolulope oyefeso

🤯
Comment from : Dinelli

very helpful, ty Maxwell
Comment from : Kolya Movchan

thank you so much
Comment from : MIS 1

Dude! You did so great with this awesome! <3
Comment from : Karlo Laum

Vlookup and copy the next four rows of excel
Comment from : Mariya Tatsu

7 yrs ago - and this GIFT just KEEPS ON GIVING!! Thank you SO MUCH! I am not sure why but after multiple videos and being coached so many times, the REASONING behind the formulae was not very clear in my head I get it now! I get it It makes logical sense Thank you again!!
Comment from : L K

Simple drop down list in excel: youtube/30KxaxhUvDs
Comment from : Negin Rostamikia

I am pulling back a N/A for my vlookup? I am following the steps to the letter
Comment from : Shirley Haywood

im no professional but im pretty sure Vlookup stands for Vertical lookup not value lookup
Comment from : Agastya Sharma

Very helpful! Thank you so much! Quick question - if I send this file to others, will they be able to see the values as there is a formula available If they will only see the formula, how can I change it to the specific values? Thanks
Comment from : Ashraf Gomaa

Most helpful VLookup video I've watched Literally saved my life today Thank you!!!!
Comment from : Kyla Gifford

Thanks!
Comment from : Ștefan Cantoriu

Thank you, i have been struggling with this a lot and your video made it easy
Comment from : Kev & Nate

Slayer idol fitri
Comment from : Zakaria Zakaria

THANK YOU
Comment from : edson macamo

It didnt work for me 😢
Comment from : Besnik Sytari

Its just says #n/a for me??
Comment from : Ash Kin

Thanks for this tutorial Can you also look up non-number(like words)br as well?
Comment from : Sara Lee

Thank you!
Comment from : Kiwi_Kimmy

Thank you for a great lesson I just started a new job and I have to use vlookup I could go to work on Monday feeling confident
Comment from : Elizabeth Peters

Hi sirbrI applying the same formula, but nothing happens, I try my best but failed
Comment from : Afsar Khan

Very easy to follow
Comment from : Kristy Pate

Thank you so much! This video and the training files have been game changing for me
Comment from : Liz McCluskey

Hey! I loved you video it was soo helpful!brBut I need helpbrI did step by step everything you said and I works great on my computer brBut when I open it in another computer It doesn’t work…br(We all have all of the files in our computers) please help me
Comment from : מרין יפה

Very good explanation
Comment from : Marie Florie

vlookup stands for vertical lookup
Comment from : Hassan66

Thank you so much I have been able to do my work well after watching the above video You are great
Comment from : alfred okello

Maxwell, i am trying to conduct Vlookup between 2 excel files & its showing #N?A error, do you have any recommendations why this error can come?
Comment from : Varun Birthire

This doesn't work
Comment from : Jamathon

how can use vlookup for multiple column?
Comment from : kwisanga ernest

The Best V-Lookup with multiple worksheets tutorials I've reviewed Thanks
Comment from : Edward Handshy

Extremely helpful! I was finally able to do this correctly
Comment from : Lena Stoots

Thank you!
Comment from : Bakyt Parman

Excellent ! I am glad I found you as the greatest teacher Thanks a lot Maxwell for your very well prepared tutorials, for your hard work, dedication Looking forward for more lessons
Comment from : Jo Jo

When looking up the value in the left most column, does this value have to be in your second workbook? What if I only have a few values in this column in the 2nd workbook, will the formula still return results in column 4 for example?
Comment from : Jaspreet Parmar

Hello, I have a region in a column and a matching district in another column Some of the regions have the same district names so I need to search both elements I need a return of a third element on another workbook which is an ID Can you please help me? I have been trying to use xlookup but keep geting different error messages Thanks
Comment from : Sarah Greene

Well explained , bravo!
Comment from : Vivacious234

Thank you Sir
Comment from : OMWAMI WAFULA

Please share data file for practice
Comment from : Metropolis Campus 2

This is amazing! I was able to query THOUSANDS of lines of excel data in seconds!!! Thank you!
Comment from : Hiram M

Question: Could you use a zero after the last argument in the v-lookup?
Comment from : Question & Research

thank you for wonderful teaching please help how do i use vlook up on two workbooks to check if the information is the same
Comment from : Abigail Mgwisi

Hi Max, I am essentially doing the exact same thing as you did in this video but I get the N/A error when I do it Any thoughts?
Comment from : Kulvinder Grewall

Thanks
Comment from : Koem Borana

Do we still have to use vlookups because other new functions came up like indexmatch, dax, something like that
Comment from : Tut Secret

I tried this and the result message said I entered too many arguments for this function
Comment from : Julie Chambers

Im wondering do both workbooks involved have to be linked to each other some how? Can I just choose any separate workbook and access data to incorporate from that particular one? Lastly, do all of the data being connected need to be in "table format
Comment from : Annette Hemstock

If underwstand it is very simple to do the task using vlookup
Comment from : VINAY KUMAR MEDAVAKA

need sheet for practice
Comment from : Harish veeranki

This video is helpful I am able to perform it without watching till the end
Comment from : Azael Tumaini

Thank you! Exactly what i was looking for to do between multiple documents Thx for taking the time to share this :)
Comment from : Nithin Gambhir

I believe this is a very good tutorial A person can easily learn from this video Thank you
Comment from : Syed Hassan

hi may i ask how to fixed #ref if vlookup in two different workbook when reopening the workbook
Comment from : Muhammad Faris Omar

Can we do this across 12 workbooks? 😅🥲
Comment from : Cindy Sanchez

Thank you so much ❤️brbrI learnt vlook by seeing your video
Comment from : Bhagya Shree

THANKS
Comment from : edson macamo

This is very well explained I am learning vlookup for the first time and this made so much sense! Thank you!
Comment from : Kandy Hill

Could you pls prepare a new clip on how to extract data from multiple columns This one extracts only from only ONE column, how about extracting data from column B(2), F(6) and J(10),,
Comment from : Eternal Bahoo

Thank you very much Maxwell, I have enough got the knowledge, thanks for your contribution
Comment from : Mohamed Farah

What is the printer CCS or whatever
Comment from : Mark OFORI

Thank you
Comment from : Praveenvlogs@Bangalore

Epic explanation, thank you!
Comment from : Kyle Harvey

This is so helpful Thank you so much!
Comment from : Jay & Colleen Sanders

this is totally my life saver, learning excel at working hour but feel zero guilty
Comment from : qiaoling liu

Hi I have a worksheet which I update weekly This worksheet has been sent to various people to update the actions in it and they share back to me and the I use that to update the worksheet that's with me The problem is I have to check each value in the worksheet they share and uodate the values in mine, basically using "closed" It's tedious How do I do it? It'd been easier sharing it with them on Onedrive but it asks for permission always Help me!
Comment from : Pelumi Fatunsin

Thanks for the video how to get multiple values based on vlook up value ? we are getting first value only but we need other values as well for example parts have multiple locations thank you
Comment from : dreambig services dreambig

VLookup stand for Vertical Lookup, not Value Lookup There is also HLookup: Horizontal Lookup
Comment from : Hakenaton

Super
Comment from : Silvia s

If you update the workbook on the right will the workbook on the left get updated automatically?
Comment from : Ray Torres

Internet explorer is faster than you
Comment from : Saikrishna Chelagani

I have watched SO many YouTube videos trying to learn vlookup This is BY FAR and away the best THANK YOU!
Comment from : Ethan Lievense

Thank you very much!!
Comment from : JarJar JoJo

I need help in regards to multiple vlookup from different workbook in WPS, can u help me?
Comment from : AK

Huge help! Thanks
Comment from : JosuffM

Thank you!
Comment from : Niteesh Bihade

Your mouse movements are very smooth and seem to accelerate to the destinations, landing with great accuracy, so much so that it looks automated Are you using a separate program for that?
Comment from : Nathan Breeze

Max, thank you so much for the video, great instruction and example
Comment from : Osaze J

I cant download your excel to practice along Your excel is no longer avail Its sad
Comment from : Fiona Liewina

I'm in love with you thank you for making this, I have been trying to figure this out for my assignment for hours and you made it so understandable
Comment from : Nichole Osei

This video should be 6 min long
Comment from : Aleksandar Marković

I really enjoyed watching this video I am also wondering if you have one on one class for Excel for P6( Primavera Scedulers)
Comment from : Gabriel Aikhionbare

You are the only person who explained perfectly ❤️ really without freezing the cell ❤️thank you ! Sir ❤️💯
Comment from : black pearl

Hi Max,brThank you for sharing! I’m new to the excel world and my new job is demanding me to use it a lot! 😬 I have to say is very confusing for me right now, I hope to be able to understand it someday! 😌
Comment from : lupeayala86

please give me the access to google drive
Comment from : Tides Of Knowledge

Awesome!
Comment from : Lavender Lace

You’re the 🐐
Comment from : Jacob Wiseman

This video was recommended to me I'm unable to access the practice files via the link provided--are they still available?
Comment from : n8rab

Youre a great teacher :)
Comment from : Kagiso Maleka

That helped Thanks!!👍
Comment from : Aanshi Shrivastava

Thank you for this!! Was pulling my hair out trying to get this to work I was taught wrong so it was giving me poor results!
Comment from : Jess Washington

how do you get the detail vise versa? example the deduction per dynamic data?
Comment from : Galangtambay

Well explained definitely going to apply this
Comment from : FSC

Thank you for this! I have been going in circles trying to figure out what I was doing incorrectly This was so easy to understand! You’re a lifesaver!
Comment from : thisisbetty