Видео


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

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

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



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


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

Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 277056
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
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 370996
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics of Data Analysis at Highline Community College Professional...
INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 140714
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm This video is a part of VLookup Week: http://vlookupweek.wordpress.com There...
Office 2013 Class #19: Excel Basics 1: Excel Grid, Formatting, Formulas, Cell References, Page Setup
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 39183
Download files: https://people.highline.edu/mgirvin/AllClasses/216_2013/Content/04Excel/Excel2013.htm This video teaches: 1. Excel Grid: Columns,...
Vlookup Excel Best
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 570400
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
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 115986
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
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 257514
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)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 41736
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm This video is a part of VLookup Week: http://vlookupweek.wordpress.com Learn...
Tour Of Excel: Formulas, Formatting, Sort, Filter, PivotTables, Charts, Keyboards
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 734929
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm (all the way at bottom in "Other Excel Series" section) Highline Community...
SUMIFS Function: Adding with Criteria 36 Examples & SUMIF function, Excel Magic Trick 978
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 54752
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn how to add with one or more criteria (conditions) using SUMIFS and...
Ctrl + Shift + Enter: Excel Array Formulas #01: Review Formula Basics (15 Important Examples)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 35845
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
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 432198
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 for Accounting and Finance - Northwest Accounting Educators Conference 2012 - NAE 2012
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 90233
Download Excel File: http://people.highline.edu/mgirvin/ExcelIsFun.htm In this video Mike excelisfun Girvin presents these topics: 1. Efficiently...
Excel Magic Trick 787: Conditional Formatting Basic To Advanced (30 Examples)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 123598
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...
Highline Excel Class 19: Advanced Filter Extract Data 9 Examples
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 128428
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm Learn about using Advanced Filter to extract data from an Excel List /...
Build a KPI Dashboard in 5 minutes
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 350081
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...
Excel Basics #23: VLOOKUP function formula
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 246814
The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. #23 Video topics: 1)VLOOKUP function formula...
Highline Excel 2013 Class Video #35: Excel 2013 PivotTables: Basic To Advanced 58 Examples
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 54398
Download workbook: http://people.highline.edu/mgirvin/AllClasses/214_2013/214/Busn214_2013.htm This is the Highline Community College Class,...
Highline Excel Class 20: Pivot Tables 20 Examples
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 161974
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm See these 20 PivotTable Pivot Table examples: 1 Proper Format 2...
CHOOSE Function Beginner to Advanced 12 Examples (Excel VLOOKUP WEEK Video #5)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 25846
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm This video is a part of VLookup Week: http://vlookupweek.wordpress.com Unlike...
Excel Cell References 15 Examples Formulas, Conditional Formatting & Data Validation
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 252213
Download file: http://people.highline.edu/mgirvin/excelisfun.htm This 50 minute video shows 15 examples of how to use Cell References: 1) Relative...
Office 2010 Class #39: Excel VLOOKUP Function Formula Made Easy (3 Examples)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 95696
Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic...
Create a searchable drop down list in Excel
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 112437
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....
Tutorial - Excel 2010 - 10 Things you must know
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 1232282
Tutorial explaining 10 of the most common must-know features in Microsoft Excel 2010, Excel is used world-wide and this tutorial shows slightly...
Highline Excel Class 40: VLOOKUP 11 Unusual Examples
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 45972
Download Excel file: http://people.highline.edu/mgirvin/excelisfun.htm See these 11 VLOOKUP tricks: 1.VLOOKUP algorithm 2.VLOOKUP, Named Ranges,...

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

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

Автор Joy Christian (13 дней)
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

Автор Goos van den bekerom (7 дней)
Very nice guide!

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

Автор Mark Stack (16 дней)
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!

Автор Muriel Lacida (21 день)
Thank you so much. Your a blessing. ;)

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

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

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

Автор imran hasan (1 месяц)
thanks so much for the video ..... 

Автор Elshad Azimov (1 месяц)
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 (2 месяца)
You are just Amazing Bro. Keep helping Dumb like us!. Thanks a lot. 

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

Автор Thais Gomez (2 месяца)
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 (2 месяца)
Honestly you are the best 

Автор Yang Gao (2 месяца)
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 (2 месяца)
Good presentation, near to excellent

Автор TammyG Wang (2 месяца)
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 (2 месяца)
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 (2 месяца)
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 (2 месяца)
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 (3 месяца)
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 (1 месяц)
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 (3 месяца)
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 (3 месяца)
OMG life saver... This and Pivot tables are an accountant's bread and
butter.

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

Автор Nick Equis (1 месяц)
Badger?

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

Автор MrBigEnchilada (1 месяц)
that's an epic video

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

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

URL 
Ссылка 

Поиск Видео

Top Видео

Top 100 >>>

Видео

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