Видео


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

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

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



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


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

Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 262094
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...
Ctrl + Shift + Enter: Excel Array Formulas #01: Review Formula Basics (15 Important Examples)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 34018
Download files here: http://people.highline.edu/mgirvin/excelisfun.htm EXCEL ARRAY FORMULAS WORK THE SAME IN ANY VERSION OF EXCEL!!! This video...
Tour Of Excel: Formulas, Formatting, Sort, Filter, PivotTables, Charts, Keyboards
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 716858
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm (all the way at bottom in "Other Excel Series" section) Highline Community...
INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 137337
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm This video is a part of VLookup Week: http://vlookupweek.wordpress.com There...
Vlookup Excel Best
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 563923
Vlookup Function http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp This video is an introduction to the Vlookup function in...
Using Excel 2010 - Full Tutorial on the Various Functions
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 102526
Data file for this video: https://drive.google.com/open?id=0BxJ3Dt4HnUkrU0FBelFhdnRrdWM&authuser=0 This is a full tutorial on the following...
Improve your efficiency in Excel -- VLOOKUP and Pivot Tables by 7city.com
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 244661
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...
LOOKUP function Beginner to Advanced 23 Examples (Excel VLOOKUP WEEK Video #2)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 40849
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm This video is a part of VLookup Week: http://vlookupweek.wordpress.com Learn...
SUMIFS Function: Adding with Criteria 36 Examples & SUMIF function, Excel Magic Trick 978
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 53758
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to add with one or more criteria (conditions) using SUMIFS and...
Office 2013 Class #45, Excel Basics 27: VLOOKUP Function Made Easy 24 Examples - How To Use VLOOKUP
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 11334
Download files: https://people.highline.edu/mgirvin/AllClasses/216_2013/Content/04Excel/Excel2013.htm This video teaches: 1. What VLOOKUP does...
Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 248920
Download file: http://people.highline.edu/mgirvin/excelisfun.htm This 50 minute video shows 15 examples of how to use Cell References: 1) Relative...
Create a searchable drop down list in Excel
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 108147
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....
Highline Excel 2013 Class Video #35: Excel 2013 PivotTables: Basic To Advanced 58 Examples
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 50618
Download workbook: http://people.highline.edu/mgirvin/AllClasses/214_2013/214/Busn214_2013.htm This is the Highline Community College Class,...
Keyboard Shortcuts Everybody Should Know

Просмотров: 195647
Keyboard Shortcuts Everybody Should Know
Making an Excel Dashboard - Tutorial #1 Copying Widgets
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 95675
A quick tutorial describing the first steps of making a Excel Dashboard using the template from www.ExcelDashboardWidgets.com. The video covers...
Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 60393
The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Download files at:...
How to Combine 2 Excel Workbooks Using VLOOKUP
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 156449
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...
Tutorial - Excel 2010 - 10 Things you must know
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 1209195
Tutorial explaining 10 of the most common must-know features in Microsoft Excel 2010, Excel is used world-wide and this tutorial shows slightly...
How to Calculate Overtime Hours on a Time Card in Excel
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 60185
A viewer asked me to show him how to calculate the number of Overtime Hours Worked and the Payment for those hours on a Time Card in Excel. Hew...
Introduction to Keyboarding
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 108798
Excel Basics #3: Formulas w Cell References
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 225469
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #3 Video topics: 1)Formulas 2)Equal sign =...
Introduction to Writing Excel Macros (VBA)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 944227
This video introduces the creation of macros in Excel using VBA. The intro is oriented towards engineers and is part of a course I teach in an...
Excel Power Tips: Useful Techniques for Excel Lists, Drop Downs and Data Validation
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 137966
Download sample workbook to follow along at: http://www.launchexcel.com/excel-dropdown-list-data-validation In this 20 minute episode we'll look...
Highline Excel Class 07: VLOOKUP function formula 7 Examples
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 223494
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm Learn about: 1)VLOOKUP to lookup an exact match 2)VLOOKUP to lookup an...
VLOOKUP Introduction, Explanation, Example in Excel (1 of 2)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 175794
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....

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

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

Автор Phil Morrison (1 день)
That was great!!!! Keep up the good work!

Автор Mark Stack (2 дня)
Got a job because of this video and even a promotion. Shame more people
aren't watching it! Can only image how many billions of dollars your
video's have saved companies in productivity!

Mike, you are EPIC!

Автор Krishna Kishore (9 дней)
thanks a lot i got job because of you

Автор imran hasan (17 дней)
thanks so much for the video ..... 

Автор Elshad Azimov (16 дней)
Thank you very much fot this best tuitorial!!!

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

Автор AKASEMfly (1 месяц)
This video is super duper good. Thanks Mike!!!

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

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

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

Автор Hari Krishna Rao Samineni (1 месяц)
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.

Автор sahazad shad (1 месяц)
You are just Amazing Bro. Keep helping Dumb like us!. Thanks a lot. 

Автор Kaiyi He (1 месяц)
Thanks bro, it really helps.

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

Автор Mohamed Farahat (1 месяц)
Honestly you are the best 

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

Автор subhan mohammed (1 месяц)
Good presentation, near to excellent

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

Автор Ramdhani Pratama Putra (1 месяц)
I just finished watching and practicing the whole video. Dude I can only
say you saved my life by providing this tutorial.

Wishing you a good karma ahead of you.

Автор Aniket D (1 месяц)
its beautiful...jst wat I was tryin to look 4...covering each nd every part
of d various lookups..Thanks a lot 4 uploading it...

Автор S McKay (1 месяц)
This is absolutely the best tutorial I have seen--it has opened my eyes to
a combination of functions I didn't even think about. Thank you so much,
keep up the good work

Автор bluneptune89 (2 месяца)
This is great, you should be a teacher because you're very good at it and I
can tell you're passionate about this. Thank you.

Автор John Masinde (2 месяца)
Too cool. Thank you.

Автор AIL2702 (2 месяца)
Great video,Great Voice, Great Quality, and above all Great Explanation.
Thanks a lot, clears my lots of doubts.Thanks Thanks Thanks

Автор JungHo Park (2 месяца)
Hey! Such a useful video! You saved my time and project!
Thank you sooooooooooooooooooooooo much!

Автор Diego Silva (2 месяца)
been trying to figure out for month how to use left look up for my problem
finally got it 44 min in to this vid. awesome info all of this!!!

Автор Roman Vidrevich (2 месяца)
Great Videos! How would you perform a mid function in the case you
presented if numbers or text of differing values?
Thanks!

Автор speedtrls (2 месяца)
This is actually a beautiful video if you add Daft Punk's "Random Access
Memories" in the background.

Автор Anthony Mok (2 месяца)
Great video. I have a question though.
My lookup values are numbers and I am trying to use vlookup to see which
words correspond with which number. However, it keeps returning a N/A
error. I have gone through and fixed all the rookie mistakes. Does vlookup
not work with numbers?

Автор Elenoa Ducia (2 месяца)
can you please show me how to do the vlookup for generating a report sheet
for any student by entering the student number into a cell

Автор rodinian777 (2 месяца)
YOU ARE MY HERO! THANK YOU!

Автор Hari Krishna Rao Samineni (1 месяц)
Awesome, thank you Sir

Автор Thiago Krachinski (2 месяца)
This tutorial helped me a lot! Thanks so much man!

Автор VillaTillAyeDie (2 месяца)
Hi there, I work in a UK Car dealership & use an Excel spread sheet for
working out costs. I am trying to work out a vlookup or array to
distinguish; model type vs factory option vs cost. Do you think its too
much to do? I would be OK for you to take a look at it the spread sheet &
let me know! Best rgds - Phil

Автор Alvin Nartey (2 месяца)
Interesting ...

Автор 76irodriguez (23 дня)
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. 

Автор Israel Alvarado (2 месяца)
What can I say? Everyone has thank you already.. I really like it and I
hope that things are great for you... We learned from you so now we show to
others what we learned... @everyone else let's be fair. 

Автор Ngoc Nguyen (2 месяца)
You are wonderful! I love each of your video, full of great materials and
energy in your lecture.
really appreciate your generosity in sharing your knowledge.

Автор Mohamed Mubeen (2 месяца)
OMG life saver... This and Pivot tables are an accountant's bread and
butter.

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

Автор Nick Equis (25 дней)
Badger?

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

Автор MrBigEnchilada (26 дней)
that's an epic video

Автор Adrian Booth (3 месяца)
Excellent video! Thank you

Автор Candy Chu (3 месяца)
thank you so much! it is a great tutorial. Love~

Автор Cathelina Salas (3 месяца)
Thank you for this video!

Автор sylvia katabaazi (3 месяца)
You are absolutely a God-sent! Until I watched your videos, I dreaded the
word Vlookup! I was also having trouble with the different formulas in
Finance (in Graduate school) until I watched your video. Soon, I was the
one helping my fellow students. Thank you again.... :):):):):)

Автор Shu Ki Hui (3 месяца)
I'm going to have an job interview tmr and will have to pass their vlookup
and pivot tables tests! So I looked them up on youtube and found your
videos! They are so useful and I think this is the best vlookup tutorial
video ever, easy to understand, well organised, comprehensive and clear!
Thanks so much for your sharing! It is fun! I feel like an expert now! :D 

Автор Narendra Kumar (3 месяца)
good quality with great knowledge.....

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

URL 
Ссылка 

Поиск Видео

Top Видео

Top 100 >>>

Видео

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