Видео


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

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

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



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


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

Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 371257
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 Data Analysis: Sort, Filter, PivotTable, Formulas (25 Examples): HCC Professional Day 2012
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 440933
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics of Data Analysis at Highline Community College Professional...
Excel for Accounting and Finance - Northwest Accounting Educators Conference 2012 - NAE 2012
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 100542
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm In this video Mike excelisfun Girvin presents these topics: 1. Efficiently...
Excel Magic Trick 781: Three Way Lookup: INDEX and MATCH and Concatenated Ranges & Cells
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 90236
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...
Vlookup Excel Best
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 617410
Vlookup Function http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp This video is an introduction to the Vlookup function in...
Improve your efficiency in Excel -- VLOOKUP and Pivot Tables by 7city.com
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 343735
Does Excel scare you? Is there often a time when you look at a spreadsheet (or need to create one), and realise that you would be so much better at...
Build a KPI Dashboard in 5 minutes
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 379575
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...
Using Excel 2010 - Full Tutorial on the Various Functions
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 197599
Data file for this video: https://drive.google.com/open?id=0BxJ3Dt4HnUkrU0FBelFhdnRrdWM&authuser=0 This is a full tutorial on the following...
Tour Of Excel: Formulas, Formatting, Sort, Filter, PivotTables, Charts, Keyboards
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 846743
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm (all the way at bottom in "Other Excel Series" section) Highline Community...
Keyboard Shortcuts Everybody Should Know

Просмотров: 221962
Keyboard Shortcuts Everybody Should Know
Ctrl + Shift + Enter: Excel Array Formulas #01: Review Formula Basics (15 Important Examples)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 44676
Download files here: http://people.highline.edu/mgirvin/excelisfun.htm EXCEL ARRAY FORMULAS WORK THE SAME IN ANY VERSION OF EXCEL!!! This video...
Excel Lookup Series #1: VLOOKUP Function 1st Example
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 439574
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 Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 77944
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to: 1. Select From Drop Down and Pull Data From Different Sheets using...
How to Combine 2 Excel Workbooks Using VLOOKUP
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 219159
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...
VLOOKUP Introduction, Explanation, Example in Excel (1 of 2)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 194274
http://www.TeachMsOffice.com Part 1 of 2 Here, I explain what the VLOOKUP() function in excel is; what it does; and how it can be useful for you....
VLOOKUP Excel 2010 (Advanced)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 126558
Teaches you how to use a VLOOKUP function within Excel 2010. This video goes over common mistakes and shows how to fix them.
Making an Excel Dashboard - Tutorial #1 Copying Widgets
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 126066
A quick tutorial describing the first steps of making a Excel Dashboard using the template from www.ExcelDashboardWidgets.com. The video covers...
Highline Excel Class 19: Advanced Filter Extract Data 9 Examples
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 134744
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm Learn about using Advanced Filter to extract data from an Excel List /...
LOOKUP function Beginner to Advanced 23 Examples (Excel VLOOKUP WEEK Video #2)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 46783
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm This video is a part of VLookup Week: http://vlookupweek.wordpress.com Learn...
INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 159973
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm This video is a part of VLookup Week: http://vlookupweek.wordpress.com There...
VLOOKUP Between Separate Workbooks and Worksheets in Excel
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 266405
http://www.TeachMsOffice.com This will teach and show you how to use the vlookup function between separate worksheets and workbooks in excel. You...
Excel Basics #23: VLOOKUP function formula
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 261142
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #23 Video topics: 1)VLOOKUP function formula...
Office 2013 Class #19: Excel Basics 1: Excel Grid, Formatting, Formulas, Cell References, Page Setup
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 58348
Download files: https://people.highline.edu/mgirvin/AllClasses/216_2013/Content/04Excel/Excel2013.htm This video teaches: 1. Excel Grid: Columns,...
How to Do a VLOOKUP in Excel - Video Tutorial
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 598784
http://vitamincm.com/excel-vlookup-software-tutorial/ This video shows you how to use MicroSoft Excel's VLOOKUP function to compare values in two...
Highline Excel 2013 Class Video #35: Excel 2013 PivotTables: Basic To Advanced 58 Examples
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 74788
Download workbook: http://people.highline.edu/mgirvin/AllClasses/214_2013/214/Busn214_2013.htm This is the Highline Community College Class,...

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

Автор ExcelIsFun (9 месяцев)
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

Автор 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

Автор John Sarantakos (1 месяц)
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

Автор jaffer ghoghari (1 месяц)
This video is epic, I really learned a value lesson of vlookup and do
practices all tricks and techniques at my work place. I love his voice you
are a dynamic tutor..

Автор Davo Devigne (6 месяцев)
You should charge for this stuff! fantastic!

Автор Yang Gao (5 месяцев)
This deserves way more likes and recommendations. Trying to master excel!

Автор Miguel Caballero Sierra (2 месяца)
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

Автор Kamal Zharif Jauhari (5 дней)
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.

Автор refticon (23 дня)
You are my hero; I've already ordered 2 of your books, I look forward to
discovering more !

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

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

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

Автор 1fluxed . (1 месяц)
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!

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

Автор Daniel Roca Iglesias (1 месяц)
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 (4 месяца)
sir would you be so kind to create a vid/tutorial for VBA using excel?
thanks in advance sir

Автор nafu p (2 месяца)
simple......good guide tomorrow I have an interview its little bit late but
helped me to get an exact idea of what V look up is .........thankz a lot

Автор i.rodriguez (4 месяца)
I'm trying to make a table that shows on a column the last time a customer
received service taken from a list of invoices on another sheet, but I need
it to work regardless of the order that the list is sorted in.
I need the table of invoices to be sortable so I can sort it by dates,
customer's name or last name, etc.
But on the other sheet I want to show a CustomersList that has the last
date of service that updates automatically when you input a new invoice on
the InvoiceList sheet.
Both lists have FirstNames and LastNames in separate columns (FirstName
before LastName). I hope it was clear what I'm trying to say.

This is the formula I was trying, but it's not working the way I want it to
work:

=LOOKUP(2,1/MAX((Table510[[FIRST NAME]:[LAST NAME]]=Table5[[FIRST
NAME]:[LAST NAME]])*Table510[SERVICE DATE]),Table510[SERVICE DATE])

Any advice? Don't know what I'm doing wrong.
I'm using Excel 2010, by the way. I believe it should be similar in 2007
and up. 

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

Автор celcus d (2 месяца)
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.

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

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

Автор kautilya21 (24 дня)
http://people.highline.edu/mgirvin/Ex... is down!!

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

Автор Paul MacDonald (2 месяца)
That was excellent! Really well taught and explained thank you for your
time and effort putting that together.

Автор Sam Marsh (1 месяц)
This was Great Help, Thank you :-)

Автор Joy Christian (3 месяца)
You are doing really great job
How do i combine 3 colums, in your video u used =B9&"-"&C9 @36:47 ..Can I
use =B9&"-"C9&"-"&D9 ????? thanks

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

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

Автор starrynightrhone (3 месяца)
BEST VLOOKUP tutorial on YouTube!!!

Автор John blanco-bello (2 месяца)
Very good tutorial, you don't over complicate things which makes it very
easy to learn!

Автор MysticCurse (20 дней)
Hey thank you so much for this video. It helped me out a ton. Greetings and
cheers from MSU! Thanks Again Mike! :D

Автор Emily Lakie (1 месяц)
I really enjoyed this! Very informative. But, I'm a little lost. I'm trying
to log grades and gpa's for a school. Is there any way I could email you,
and you could help me with a formula?

Автор alex lee (3 месяца)
excellent job!!! i love it!!! thank you so much.

Автор Sean Cordy (4 месяца)
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).

Автор Stoyan Mitrev (1 месяц)
You are a great person!

Автор Alberta (4 месяца)
YOU ARE A STAR!!! Seriously. Just started an analyst job in banking and you
have saved me some embarrassment lol

Автор Ming Kong (2 месяца)
Thank you so much! this is the best ever!

Автор Yang Gao (5 месяцев)
I tried ALL examples in Excel 2011 on my MacBook Pro; I learned really a
lot! I had to stop several times because most of the keyboard shortcuts
(F4, F9, etc) in your video only works in Windows so I have been searching
and testing equivalents on my Mac... Q1: How to enter array formula in mac?
I have been trying every combination of cmd, ctrl, shift...however I still
can not enter it. Q2: I love the expandable range, I practiced and got the
vlookup cell under "price" expanded, however the options list I saw when I
clicked the data validation little arrow did not expand while the whole
table expanded. Help wanted with these questions, and thanks again for this
wonderful, hour-long video!!!

Автор Bhumi Shah (4 месяца)
Great help! I though Vlookup would be tough for me, as I only know basics
of Excel. But this video help me a lot and made me learn my techniques. 

Автор Muriel Lacida (3 месяца)
Thank you so much. Your a blessing. ;)

Автор Supriya Supriya (15 дней)
Hi,
can you tell how to work on merged cell with vlookup.
i:e for example i have date in A, B & C columns and in column "A" i have
merged 3 rows (a1,a2 & a3) with 1 word or name and i have 3 different names
or address in b1,b2 &b3 followed by zip code in column "C".
here i want 3 values of column "B" with 1 reference that is column "A"
reference. i have tried with vlookup but its showing only value for B1 only.
can you help out on this case.

Thanks.

Автор Anna Lola (2 месяца)
Thank you so much for sharing this vid

Автор Hari Krishna Rao Samineni (5 месяцев)
Just gone through the entire video, simply amazing, definitely a thorough
and hard work of many many years. You are doing a great service. God Bless.

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

Автор Nitish Sharma (4 месяца)
hi, really an amazing video.I need some help though.got some new hire list
with all the emloyee id, operator id, email ids. Also another file that is
exhaustive which contains aprox 5000 names, id and some more details.i need
to check if all the new hire are in that exhaustive list or not.Whoever
are there in that list needs to be included in the table.So can you please
help me out.The file has got dublicate name also, though their operator id
is different.what do i do?

Автор Elshad Azimov (4 месяца)
Thank you very much fot this best tuitorial!!!

Автор TammyG Wang (5 месяцев)
this is exactly what I'm looking for in a tutorial... was about to give up
looking for a good tutorial. very nicely done! thank you!

Автор jkd (1 месяц)
Finally found this one :) thank u so much for this wonderful tutorial..
I just don't get the 44:54 part? why does he need to type the number 7?
and latter type -1 and he gets 6?, sorry for the question. I'm just really
self studying this one.. tnx

Автор Khalil Medina (4 месяца)
Thank you very much. I am so grateful. It is amazing.

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

URL 
Ссылка 

Поиск Видео

Top Видео

Top 100 >>>

Видео

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