Видео


VLOOKUP Function Beginner to Advanced 26 Examples: How To Use Excel VLOOKUP Function



Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
This video is a part of VLookup Week: http://vlookupweek.wordpress.com

Excel VLOOKUP is one of the most important functions because everyone needs to look stuff up. Not only that, but if you want to get a job, you must know VLOOKUP.
In this video learn everything you need to know about VLOOKUP in 1 video.
Here are the topics (minute marks jump you to that part of the video):
1. VLOOKUP = V = Vertical ( min)
2. Why so common? Because everyone needs to look stuff up ( 00:43 min)
3. VLOOKUP Delivers a value to a cell: Extract Match ( 2:37 min)
4. VLOOKUP #N/A and IFERROR or IF ( 5:25 min)
5. VLOOKUP and Data Validation ( 8:10 min)
6. VLOOKUP with Named Range ( 10:34 min)
7. VLOOKUP as Formula Element ( 17:24 min)
8. HLOOKUP = H = Horizontal ( 18:25 min)
9. VLOOKUP Delivers a value to a cell: Approximate Match ( 19:40 min)
10. VLOOKUP with table on different sheet ( 24:00 min)
11. VLOOKUP with table in different workbook ( 25:56 min)
12. Show Full Record: Numbers above column header ( 27:15 min)
13. Show Full Record horizontally: COLUMNS Function ( 30:20 min)
14. Show Full Record vertically: ROWS Function ( 32:28 min)
15. Show Full Record: MATCH Functions ( 33:40 min)
16. Two Lookup Values: Add join column as first column in table ( 35:40 min)
17. Two Lookup Values: Join columns in formula and use CHOOSE function ( 38:50 min)
18. Partial Text Lookup: LEFT and SEARCH Functions ( 43:22 min)
19. Partial Text Lookup: MID Function ( 45:37 min)
20. Partial Text Lookup: RIGHT Function ( 48:08 min)
21. TRIM and VLOOKUP: Space in lookup value ( 48:57 min)
22. TRIM and VLOOKUP: Space in 1st column of table ( 51:03 min)
23. VLOOKUP with 3 lookup tables: CHOOSE Function ( 53:20 min)
24. VLOOKUP: Two Way Lookup with VLOOKUP and MATCH ( 58:36 min)
25. VLOOKUP: Variable Tax Rate, 3 VLOOKUPS in one formula ( 1:00:18 min)
26. VLOOKUP and Table feature for Dynamic ranges ( 1:05:17 min)

VLOOKUP Shark WEEK
How To Use Excel VLOOKUP Function
Learn Excel VLOOKUP Function
VLOOKUP made easy
Excel VLOOKUP
Excel VLOOKUP Function


Просмотров: 1849619
Добавлено:
Длительность: 1:8:3
Комментарии: 1515

Тэги для этого Видео:



Найти больше видео в категории: "27"
Видео загрузил:
Показать больше видео, загруженных


Похожие видео:

Excel Basics #23: VLOOKUP function formula

Просмотров:
Highline Excel 2016 Class 03: Data Analysis Fundamentals: PivotTables, Power Query & Data Model

Просмотров:
Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards

Просмотров:
Excel Magic Trick 915: What Exactly Does VLOOKUP Do? What Is Purpose Of VLOOKUP? 9 Examples

Просмотров:
How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX

Просмотров:
Vlookup Excel Best

Просмотров:
VLOOKUP Introduction, Explanation, Example in Excel (1 of 2)

Просмотров:
INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3)

Просмотров:
Business Dashboards In Excel for Beginners - Design and Introduction

Просмотров:
PivotTables Are Easy! 30 Examples for Highline College Professional Development Day 2014

Просмотров:
Microsoft Excel VLOOKUP Tutorial

Просмотров:
Excel Lookup Series #1: VLOOKUP Function 1st Example

Просмотров:
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)

Просмотров:
Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)

Просмотров:
Excel Magic Trick 1174: Two Lookup Values For VLOOKUP? How Do I Do That? (6 Methods)

Просмотров:
Excel Pivot Tables in 1 Hour: Excel 2013, 2010 & 2007

Просмотров:
How to Combine 2 Excel Workbooks Using VLOOKUP

Просмотров:
Excel 2007 / 2010 Tricks For Making Your Job Easier: HCC Professional Development Day

Просмотров:
Create a Scrolling Table

Просмотров:
Excel: Tips/Tricks For Large Amounts of Data

Просмотров:

Комментарии:

Автор Oscar Delgado ( назад)
Thanks a lot for this video!
You truly do a great job.

Автор lakshmanji karu ( назад)
Very useful

Автор Marchia MillerJones ( назад)
Have a quick question: at 27.00 you discuss utilizing ranges from different
files... If the data from those respective (pull from) files are altered,
will the outcomes on the spreadsheets you are working on also alter? In
other words, are the tables all HOT, indefinitely? Or can the data be
locked in never to alter, even if those reference tables are changed? (Hope
my question makes sense. Thanks.)

Автор Hector Last ( назад)
I have a question. I have a list of data numbers ex ,10 set of numbers on
the left and boxes on the right.The left are customers and the right
are boxes of cargo , if the total of the cargo is 3200 pies how can I ,by
tiping the first customer it can fill other customers for a total of
3200,or the colsest number to fill the truck.




457
1820


447
463


451
583


466
709


468
1011


470
970


473
462


497
1249


552
1000


125
1200

Автор sooraj s ( назад)
hi
can i get ur contact mail id??

Автор meiyan zou ( назад)
Thank you so much!

Автор Shaddy Omar ( назад)
it seems that the link is not working!!

Автор Kalambo Palavi ( назад)
THANKS

Автор harshita pant ( назад)
hi plz make videos on how to crack interview questions in MIS EXECUTIVE /
DATA ANALYST field cz they ask very tricky questions.. .


thank u so much ..

Автор pmarilag ( назад)
best vlookup tutorial! thanks!

Автор Jsidhu762 ( назад)
This video would make you a b lookup. The b stands for boss.

Автор vinod m ( назад)
great

Автор Misha Yufit ( назад)
Hi, cool video ! But still haven't find answer to my question..
Maybe you can help me.
I have 2 separate tables and one contain full names, the other only names.

Table 1
------------

Full name

Joe Lopes
John Travolta
Helga Johnson


Table 2
-----------

Name Value

Misha 9
Lorne 8
Joe 7
Johnson 15
King 42

-------------------------------------------------------------------------------
Result >

Table 1
------------

Full name

Joe Lopes 7
John Travolta
Helga Johnson 15


Thank you ;)

Автор Sayantani Singha Roy ( назад)
Great video, extremely easy to understand and practise. Thanks.

Автор Pinky Blue ( назад)
amazing! thanks!

Автор Bosco Ryan ( назад)
Outstanding video. So clear and concise. Life saver!

Автор MultiCadias ( назад)
My brain just exploded

Автор Michelle Thurman ( назад)
Great tutorial! Absolutely everything you need to know in a very clear to
understand way.

Автор Jacky Joey Lumanglas ( назад)
thank you so much for this tutorial. I learn a lot

Автор Grace Galman ( назад)
Thanks😊 you made it very simple and easy to grasp..

Автор Paulina Charlotte ( назад)
I love your videos! First I was a bit anxious about starting to learn
how to use Excel (thought it would be very complicated), but with your
help it is really fun! :-)
Thanks a lot !!!

Автор samir patel ( назад)
I can't download the workbooks

Автор Noel Doyle ( назад)
Brilliant tutorial. As a beginner Is their a way I can download the video
so I can use it when I don't have net connection to practice?

Автор Thipphavanh Thorlatha ( назад)
Hi

Автор Red Ranger ( назад)
ExcelIsFun is my go-to-place to find out how I can use Excel the way I
want. I really appreciate all the work that has gone into this channel.

Thank You

Автор Takdanai Cheepsaritdipong ( назад)
You are the best excel tutor
Thank you so much

Автор premaratne balasooriya ( назад)
I learn much. This is very clear presentation

Автор dalex7777 ( назад)
@ExcelIsFun this just changed my life. Thank you!

Автор hins108 ( назад)
why boomerang isn't that an aussie item?

Автор yawnyes ( назад)
Great video. Thanks.

Автор amol chandane ( назад)
Hi, Thanks for this tutorial. When we press F9 in formula it shows the
result. How to switch it back to previous formula? What's that shortcut?

Автор P. Charmin ( назад)
i have 2016 version...will u recommend i use newer 2016 tutorials?

Автор Araa Ezo ( назад)
I am so stomped, I have written out your chart EXACTLY as you have it, in
my own excel program, and I can use the vlookup function, that you use in
your first example, but my vlookups wont automatically update like yours
do, if i change the data to the left..I am entering your formulas exactly
as you have them in my copied worksheet from your video

Is there something in the settings I need to check on?

HELP, please, someone

Автор rave reyu ( назад)
Thank you so much, this video is very useful !

Автор Getachew Sine ( назад)
At 47:21 min: N/A ????? LOL.
Thanks a lot very great explanation, worksheets, chronology etc. thumbs up!

Автор Opris .c77 ( назад)
hy ... i have a cell with a indentification number wich is 1771022, and
in other cel i whant to put the birth date and the sex ...if the person is
male have a nuber 1 in fronth or female have nomber 2, and the day of birth
is to the right to left 22-10-1977how to put the day and the sex in 2
difernt cell??? best regards ... and excuze my english

Автор Paritosh Saxena ( назад)
Hello, I am looking for a solution to select a model based on feature. For
e.g If I select Keyboard, TFT and Mouse from drop down menu by list
validation, it should display Desktop.

Features Laptop Mobile Desktop
Keyboard Yes Yes Yes
CPU Box Yes
LCD Screen Yes
TFT Yes
Mouse Yes Yes
Dial Nos Yes

Автор ashtaf ahmed ( назад)
very good Thanks helpful

Автор Aleppo ( назад)
Thank its helpful

Автор Nestor Visto ( назад)
Thank you, your demo helps a lot and you demonstrated very clearly

Автор Rihan mohamed ( назад)
i love this... superb work and thanks a lot!

Автор Ebbie Hock ( назад)
I am having trouble with the VLOOKUP example #12. I matched your formula
exactly, but for some reason it is returning either the wrong last name
(almost always brings up Hughes) or an #N/A, even when I try different ID
numbers, use the helper column numbers, etc. I've cleared it and tried it
over and over, but I just can't seem to make it work!

Автор Ralph Tuckwell ( назад)
These tutorials are great and have opened the power of VLOOKUP for me!

I have a problem with VLOOKUP that I just don't understand: I have a
reference list of IDs to match against a table of data (thousands of
entries). I have 45 matches, but have identified a further 5 which just
won't match. For example, I have yp3556 in the reference list, and yp3556
in the data, but VLOOKUP doesn't match it. I have checked the format of the
cells (text) and copied the contents into the 'Find' command and it works
there. Is there something in VLOOKUP that I'm missing?

Автор Abbas Omar ( назад)
ExcelIsFun _ Is your home near to airport :D

Автор hbbbxxx ( назад)
seems like u live near the airport. could hear airplanes in ur video. :)

Автор Laurentiu Neagu ( назад)
Very good tutorial with practical examples , thank you man ! ,

Автор hbbbxxx ( назад)
simply amazing... you are clear and to the point... love it... thanks

Автор El chaella ( назад)
great tutorial. thanks

Автор Chita onRun ( назад)
Best tutorial for VLookup on the internet.

Автор Don JO ( назад)
This was incredibly valuable to me. The content and the instruction is
excellent. In 30 minutes you taught me how to do VLOOKUP! and in a way that
made it very easy to understand. I look forward to learning more from you.
Thanks much!

Автор joseph lennon ( назад)
Thank you from a complete novice in Ireland who just finished a college
assignment in excel thanks to this video. 😃😃😃😃

Автор Mohamed Osman ( назад)
You're a real MASTER ....Thanks a million

Автор Angelo Young ( назад)
amazing video...

Автор John Shervell ( назад)
wonderful but I have 2 lists one short 10 names and one long 50 names
.using vlookup to find a name from the long list in the short list ,works
ok but if it does not find the name it shows an error...I wish it to leave
the value in a cell if it does not find the name.how do I do that please

Автор adrian andrei briciu ( назад)
Excellent good explications. Thanks

Автор Edmundo Rivero ( назад)
Hi very good your video thank you

Автор Charmaine Thomas (669 лет назад)
wow this was awesome thank you very much

Автор ramya suresh ( назад)
Your way of teaching is very good, I can improve my excel skills and apply
for the job once again. Thank you! so much for sharing your knowledge.
What is the file name to dowload?

Автор Pedja Simic ( назад)
Da te pitam ja......jel jebes ti nesto?

Автор Muhammad Abbas Arif ( назад)
Thanks, this an amazing video. Posting such videos is part of community
development.

Автор Mike Nathan ( назад)
Again, thanks for posting! I had a question that I am still unsure about
and I dont think it covered or your other videos. I know you are busy but
if there is any assistance you can give me, I'd really appreciate it!

I have to enter/redeem spiffs on a monthly basis so I currently compare
model #'s that I sold to what program is available for me to redeem.
However the problem is that the models I need to compare to are not always
listed separately therefore I cannot export to excel and use VLOOKUP (since
its not on excel ,its on a website) . If you see below, its because some
lines have multiple models separated by a comma, if I copy and paste to
excel, VLOOKUP would not work properly.

EH32BR81QB $75.00
EH24BR81QS, EH24BR10QS $50.00
EH30EC45KB, EH30EC45KS, EH36EC45KB, $40.00

Is there a fix to make them all get separated into a different row like
right below?
EH32BR81QB $75.00
EH24BR81QS $50.00
EH24BR10QS $50.00


Again, any help you could offer would be so great. I have excel 2007
currently. Thanks again!

Автор Amanda L ( назад)
What if you want to find all of the dates in the spreadsheet that are 90
days or more past due. How would you do that in Excel?

Автор Andrew Bradford ( назад)
Good video man. Lots of options when someone is trying to learn the vlookup
function.

Автор Chulaka Madurapperuma ( назад)
its 2 am I'm total out of kind how to do vlookup tnx a lot u save ma day

Автор roderick mose ( назад)
Hi Guys, in the example on the 'LookUp Last' worksheet @ time 29:21 Last
Trade Entered on Specific Date, instead of using divide by one in the
formula, shouldn't multiple by one also work as it would convert all the
trues and false into ones and zeros only? i tried it but only works to some
extent!

Автор Nishad Hussain ( назад)
thanks a loooooooooooooooooooooooot man

Автор - Dee ( назад)
Very clear. Even better than my private tutor Thank you so much!

Автор Narcissus DP ( назад)
https://www.youtube.com/watch?v=08S1MC8XQsk

Автор Cassondra D ( назад)
Very Helpful. I love how concise he is and he covers various vlookups.
Highly recommend, Excellent learn

Автор Siddege Ahmed ( назад)
Thanks man! Landed a job by studying from these videos.

Автор Zaf Iqbal ( назад)
Brilliant video........I looked at VLOOKUP and thought it was a different
language but in the first 5 minutes I can't believe how easy it is !!!
Thanks you and well done on fantastic video!

Автор rucker369 ( назад)
Does anyone know how to explain what locking means, or know a video I can
watch? I can't go any further than 31:27 till I know what locking mean

Автор Khim Seily ( назад)
Why search function is put 7? And why minus 1?

Автор Diana Michalevic ( назад)
Amazing :) Thank you very very very much :)

Автор Diosdado Miolata ( назад)
superb!!!!

Автор Harish Krishnamurthy ( назад)
awesome!

Автор tarine felix ( назад)
@ExcelIsFun Really great tutorial! I have a question though.. can you put a
vlook up for a whole category? example : there are 20 data, there are 4
categories (so 5 data have similar information), I want to look up one
category, is there a function for that?

Автор Kithsiri Advertising ( назад)
Thank U Very much. I learn Lot Of things In This Video .Thank U again . TC

Автор Tony Perez ( назад)
This is a great way to learn and advance in excel, thank you for making it
easy to understand.

Автор Amanda Villaparedes ( назад)
I have to bump up my excel skills for job applications since they test as
part of the interview process. Your videos are amazing :)

Автор Karla Duenas ( назад)
You are the best!

Автор jessie johnson ( назад)
This was so helpful to me! My college classes never provide lechures and
I'm preparing to take the MOS Excel Expert exams. i needed a source and
this was truly perfect!!

Автор Tiffani Scott ( назад)
Thank you so much this is wonderful! 37:00 is finally what I e been
searching for. I'm keeping this video very good

Автор Muhammad Naveed ( назад)
REALLY EXCELLENT

Автор md sahubar ( назад)
excellent tutorial. keep it up

Автор Callum Bannister ( назад)
I sometimes find it really difficult to explain what I want Excel to do, so
I could never really explain the issue.. This solves one of them perfectly
and is pretty simple!

Such a great resource, thank you for your time and effort! Much
appreciated!

Автор Cosmas Ezeuko ( назад)
Good job ExcellsFun. Excellent
With this kind of video free-of-charge, ignorance is a choice!!!

Автор gayatri mahapatro ( назад)
thank you sir

Автор Mei Terumī Mizukage (1056 лет назад)
I am really thank full for all the helpful tutorial.... You the best... ^_^

Автор only1barbi ( назад)
I watched 5 other videos on VLookup before finding yours. Obviously, the
first 5 didn't explain it very well or I wouldn't be here...THANK YOU FOR
SIMPLIFYING THIS FOR ME AND PROBABLY SAVING MY JOB. TY TY TY

Автор Devesh Somani ( назад)
Sir! You are God Sent! Cannot thank you enough for what you do! Thank You!
Thank You! Thank You!

Автор Yannick Morgan ( назад)
So you have to download the workbook sheet in order to do a vlookup through
the workbook pages. does anyone know where I can go for that? This is
regarding number 11

Автор Md Tofiqul Islam ( назад)
আমার জীবনকে বদলে দিছে! (Excel Magic Trick)

Автор Stephen Weiss ( назад)
I tried the vlookup with choice of 2 columns (17 in the table of contents)
in a very large worksheet. The formula only worked for the first two
rows. The remaining 735 rows produced "n/a" error messages. I wound up
creating a helper column (16 of the table of contents) but would have
preferred the other formula to keep my worksheet clean. I used the $ sign
in the arrays and then tried to remove them but nothing worked. F9 to see
the formula did not work because the size exceeded the limits. Any ideas
on what else I can try to make the choose function work?

Автор MrFriedgreentomatos ( назад)
I've just got one, No two comments, the first Thanks and the second ;
"Boom" - cheers, an excellent video

Автор harald808 ( назад)
i dint get it its seems hard or may be you dont know how to explain to the
begginer

Автор Justin Peters ( назад)
It's incredible to see someone who is so savvy with excel! Practice makes
perfect! Good stuff man! Keep them coming. If you have any room left from
your THOUSANDS of useful and beneficial videos!

Автор justin wang ( назад)
it is very useful for me ,thank you

Автор Mahfuzul Haque ( назад)
good

Автор jaena paula balbedina ( назад)
Hello sir! Your Excel-lency, Mr. Mike Girvin! I'm a big fan of your work!
You have a knack of making complicated stuff look easy peasy... It's me
again. I don't know if you're viewing the comments since I understand this
is waaay back and I did not receive a reply on my previous question. I just
need to ask though with regards to PARTIAL TEXT LOOKUP, how do you make
excel search/look up a name from a database by only the first three letter
of the last name from a random list? In other words, how do I make Excel
find the first 3 letters of any name from the list if I don't exactly know
what to put in " " when I use SEARCH?

Вставка видео:

URL 
Ссылка 

Поиск Видео

Top Видео

Top 100 >>>

Видео

Seo анализ сайта