Видео


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

Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 977,511
Добавлено: 2 года
Длительность: 68:03
Комментарии: 1252

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



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


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

INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 176202
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm This video is a part of VLookup Week: http://vlookupweek.wordpress.com There...
Excel Basics #23: VLOOKUP function formula
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 270420
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #23 Video topics: 1)VLOOKUP function formula...
Excel Data Analysis: Sort, Filter, PivotTable, Formulas (25 Examples): HCC Professional Day 2012
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 495973
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics of Data Analysis at Highline Community College Professional...
PivotTables Are Easy! 30 Examples for Highline College Professional Development Day 2014
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 21609
Download Files at very bottom of web page (Ctrl + End): http://people.highline.edu/mgirvin/excelisfun.htm Excel 2013 PivotTable Topics Covered in...
Vlookup Excel Best
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 659349
Vlookup Function http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp This video is an introduction to the Vlookup function in...
Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 94120
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to: 1. Select From Drop Down and Pull Data From Different Sheets using...
Excel Magic Trick 787: Conditional Formatting Basic To Advanced (30 Examples)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 145813
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Above Average for Sales (1:24 minute mark) 2. Below Average for Sales ( 3:18...
How to Use VLOOKUP in Microsoft Excel 2010
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 948030
How to Use VLOOKUP in Microsoft Excel 2010 from "Power Excel 2010 with Mr. Excel" LiveLessons:...
Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 445788
Download file (ALL THE WAY AT BOTTOM OF PAGE): http://people.highline.edu/mgirvin/excelisfun.htm Keyboards 0:01:47 Jump: Ctrl + Arrow 0:02:20 Go...
Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 293049
Download file: http://people.highline.edu/mgirvin/excelisfun.htm This 50 minute video shows 15 examples of how to use Cell References: 1) Relative...
Using Excel 2010 - Full Tutorial on the Various Functions
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 265771
Data file for this video: https://drive.google.com/open?id=0BxJ3Dt4HnUkrU0FBelFhdnRrdWM&authuser=0 TABLE OF CONTENTS (feel free to share the link...
How to Combine 2 Excel Workbooks Using VLOOKUP
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 266749
This is a request from one of my viewers. In his organization, two people were working on this project and he needed to produce a consolidated...
Tour Of Excel: Formulas, Formatting, Sort, Filter, PivotTables, Charts, Keyboards
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 948461
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm (all the way at bottom in "Other Excel Series" section) Highline Community...
Making an Excel Dashboard - Tutorial #1 Copying Widgets
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 148658
A quick tutorial describing the first steps of making a Excel Dashboard using the template from www.ExcelDashboardWidgets.com. The video covers...
Excel Magic Trick 781: Three Way Lookup: INDEX and MATCH and Concatenated Ranges & Cells
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 99523
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. See how to do a three way lookup when there are two row header variables...
Office 2010 Class #36: Excel PivotTables Pivot Tables 15 examples (Data Analysis)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 402637
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2010/Content/04Excel/Excel2010.htm The Excel 2010 Basics Series shows a...
Excel Lookup Series #1: VLOOKUP Function 1st Example
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 444584
See how to use the VLOOKUP function to deliver a value to cell: 1) Find approximate value from column 2 of lookup table. 2) Find exact value from...
Excel 2007 / 2010 Tricks For Making Your Job Easier: HCC Professional Development Day
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 134767
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm (workbook at VERY bottom) Learn how you can manage and manipulate data with...
Ctrl + Shift + Enter: Excel Array Formulas #01: Review Formula Basics (15 Important Examples)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 52156
Download files here: http://people.highline.edu/mgirvin/excelisfun.htm EXCEL ARRAY FORMULAS WORK THE SAME IN ANY VERSION OF EXCEL!!! This video...
SUMIFS Function: Adding with Criteria 36 Examples & SUMIF function, Excel Magic Trick 978
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 76828
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to add with one or more criteria (conditions) using SUMIFS and...
Keyboard Shortcuts Everybody Should Know

Просмотров: 239876
Keyboard Shortcuts Everybody Should Know
Create a searchable drop down list in Excel
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 176935
This video will show you step by step how to create a searchable dropdown list in Excel. This technique uses data validation and some formulas....
Build a KPI Dashboard in 5 minutes
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 397889
Build a KPI Dashboard in 5 minutes with no programming in Excel 2010 connected to a locii Insight OLAP cube. Based on a 10 million-record...
How to Do a VLOOKUP in Excel - Video Tutorial
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 742565
http://vitamincm.com/excel-vlookup-software-tutorial/ This video shows you how to use MicroSoft Excel's VLOOKUP function to compare values in two...
VLOOKUP Between Separate Workbooks and Worksheets in Excel
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 278082
http://www.TeachMsOffice.com This will teach and show you how to use the vlookup function between separate worksheets and workbooks in excel. You...

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

Автор ExcelIsFun (11 месяцев)
VLOOKUP function: Everything you ever wanted to know: In One Place! ! ! :)

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

Автор BATTLE BORN 360 (4 дня)
Question - what if I am using VLOOKUP to get the cost of an item, but then
later on the cost of the item changes. Do I need to create a whole new
price column, or is there a way to change the item cost without affecting
previous data? Take a store front for example. I use VLOOKUP to populate
the cost of a "chair". Later on, the price of the chair goes up. If I
update the item cost field, any sales I recorded previously will then
update as well. Is there a way to use VLOOKUP, then lock the field so that
it won't update when I change the item price later on? Hope this makes
sense. Thanks for a great video!

Автор MrSarky1992 (5 дней)
Hy! I hope you are reading this. So immediately when you were talking about
the Partial Text and MID function I started to wonder that "okay, but what
if that ID is not always 3". I swet blood but I came up with this solution:
- First: change the VLOOKUP table ID column to text with text to column.
- Second: use this monster:
=FKERES(KÖZÉP(A10;SZÖVEG.KERES("-";A10)+1;SZÖVEG.TALÁL("-";A10;SZÖVEG.KERES("-";A10)+1)
SZÖVEG.TALÁL("";A10)-1);D10:E13;2;0)

It's in hungarian, I believe that the exact version in english is:
=VLOOKUP(MID(A10;SEARCH("-";A10)+1;FIND("-";A10;SEARCH("-";A10)+1)FIND("
";A10)-1);D10:E13;2;0)
It's ugly as hell but believe it or not it's actually working!

Love ya!

Автор celcus d (4 месяца)
Very few have this ability to explain in the way, most can understand. And
you have got that thing in you. Thank You So Much.

Автор John Sarantakos (4 месяца)
I love you....had 1 hour to my job interview where they had an excel
test....learned all this crap right before and nailed it....thanks man

Автор Jin Aura (12 дней)
Dude, you're awesome. Thanks so much for your video and the thorough
explanations!

Автор Nagina Fathima (1 месяц)
This video is just awesome !! Lesson definitely learnt.. And we'll :)

Автор Shahriar Arif (20 дней)
7.59 , What if I want to look value using IDs instead of Boomerang name? (
"1006-634-0171" instead of Bellen) I have tried it putting
=VLOOKUP(A15,VTable,4,0), but it resulted as "N/a" if I select the whole
table (VTable). But if I do it without "Boomerang Name Column that means
[=VLOOKUP(A15,B5:D12,3,0)], it gives right answer. Can you please tell me
what is wrong that I am doing while taking the whole table? 

Автор ExcelIsFun (1 год)
Need to learn VLOOKUP? This video is the ticket!

Автор Ahmed X (1 месяц)
Thanks for such excellent tutorials!

Автор Una Sana (7 дней)
where can i download this file.? I really can't find it!
Thanks and yeah great stuff here.

Автор cosmel villalobos (22 дня)
Man oh Man ! That was some class right there! thank a lot for your input .
I was able to use vlookup for a report I needed to do!!!

Автор Maria Chat (28 дней)
Thank you ever so much!!!!

Автор Dashzeveg Bayarsaikhan (16 дней)
Thank you so much. You are the best in all the videos tutorials I watched.

Автор Alicia Moore (3 месяца)
Thank you so much. You are the best in all the videos tutorials I watched.

Автор Adam Abdullah (1 месяц)
Thank you so much , Very helpful channel ,a lot of effort for free, you
deserve more than hitting like , god bless you

Автор Quentin Daniels (1 месяц)
"Epic Video", I love it! Your passion for what you do is phenomenal!

Автор Luiza Trofeo (2 месяца)
amazing videos!! from the most beginner level to start to have an idea
what's really going on there!! great job and extremely useful! Thanks for
the time and the passion invested! I started to love learning excel! thanks

Автор maylyn castillo (1 месяц)
thank you so much.it made me efficient with my work,..very helpful.

Автор Mark Blackburn (5 месяцев)
still helpful!!!! thank you for taking the time. 

Автор Miguel Caballero Sierra (4 месяца)
Hi Mike,

Thank you so much for your amazing tutorials,

I would to ask you something about array formulas, in the minute 41:53
your notation is somthing like {"Joe|WA","JA5239658"; ...} but when I do
that my notation looks like {"Joe|WA" \ "JA5239658"; ...} which means that
my column separator is (\) instead of (,) therefore I have to do the
formula like: =CHOOSE ({1\2},B9:B16&C9:C16,D9:D16), My question is How Can
I change the symbol (\) for (,) ?

I appreciate everything you do in your channel
Greetings from Bogotá - Colombia

Автор Chinese Hacker (14 дней)
This was awesome!!

Автор Farida Zahra (1 месяц)
+ExcelIsFun can you please put more videos thx again

Автор Alex Montero (2 месяца)
Another Great video, very helpful, Thanks!!

Автор mahesh nilanka Nilanka (2 месяца)
I really want to say thanks in advance...keep up good work..well done..!

Автор mike jay perez (1 месяц)
is it possible to connect cell based from what i input? 

Автор neo greateramir (1 месяц)
I wonder if you can help me please.
I have an excel workbook with just over two hundred sheets. Each sheet is a
patient with their various blood results. Unfortunately the order of blood
results is not the same in each sheet. For example; “liver enzyme” in one
sheet may be in column “D” and in another sheet it may be in column “K”.
Is there a formula that can find the column with the heading “liver enzyme”
and then look for the highest value in that column? And if there is such a
formula, can I apply it to the whole workbook rather than separately to
each sheet one-by-one?
I would be most obliged if you could help me with this matter
Best wishes

Автор TheAdventurousPirate©™ (12 дней)
Were do i find vlookup in excel? anyway, im going to give you a thumbs up
and sub for GREAT useful info!

Автор Krishna Kishore (6 месяцев)
thanks a lot i got job because of you

Автор Sean Cordy (6 месяцев)
I'd like to sincerely thank ExcellsFun for helping me become a little more
fluent with Excel. It was this video that I started my base knowledge and
extended it to create this: 2014 Fantasy Football Drafting Tool. Very
helpful videos (like this one).

Автор Marcus Anthony Francisco (19 дней)
Vlookup Training Advance

Автор Thais Gomez (7 месяцев)
Thanks for these videos :) I'm learning so much and I'm making nice tables
and tools for my colleagues at work. Thanks heaps!

Автор Farida Zahra (1 месяц)
excel is really fun thx 

Автор Kamal Zharif Jauhari (2 месяца)
Hi, I'm trying to use VLOOKUP function on a variable that has multiple
answers. Can you offer some tips please? The answers are also under the
same column.

Автор Praveen Iyer (2 месяца)
Very good video.. very informative.. thanks :)

Автор Excel Commands Formulas (1 месяц)
Nice Videos

Автор cree (27 дней)
hi i downloaded the worksheet, I entered v lookup but the table array keep
indicating a formula error i downloaded excel 2013 i previously had excel
starter 2010 and thought it was not compatible now it still does'nt work
any advice

Автор keith noone (23 дня)
Fantastic video. Thank you so much!!

Автор refticon (3 месяца)
You are my hero; I've already ordered 2 of your books, I look forward to
discovering more !

Автор wu yuan (3 месяца)
i am an international students in us. thank you so much. i learn a lot and
get an amazing internship. thank you 

Автор onehundredcents (3 месяца)
thanks, awesome tutorial, you actually know how to teach and explain

Автор 1fluxed . (4 месяца)
This will help me no end in the accountancy job I start this week - thank
you. I like that it is basically a minute or so of what VLookup is,
followed by an hour of every possible use!

Автор Daniel Roca Iglesias (4 месяца)
Your videos are just awesome. Thank you very for helping us to improve our
excel skills. Really appreciate it. Worth every second of all videos.
Thanks

Автор Nil Sanity (7 месяцев)
sir would you be so kind to create a vid/tutorial for VBA using excel?
thanks in advance sir

Автор Lovely Jaimen (4 месяца)
ExcellsFun! Hope this will be my stepping stone for my career lol! hope I
can get higher job, thankssss... ",)

Автор Lavinia Choi (4 месяца)
simple, clear, easy to catch every step.....Thumbs up!!!!

Автор Lute Scrat (4 месяца)
you're my new excel guru!

Автор keiser soze (4 месяца)
no words to describe what you have done with all your lessons.

Автор Diaa Elsayed (5 месяцев)
You are amazing, thank you. So clear. I would like to see more of your
lessons. Appreciated.

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

URL 
Ссылка 

Поиск Видео

Top Видео

Top 100 >>>

Видео

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