Видео


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

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

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



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


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

INDEX & MATCH functions Beginner to Advanced 19 Examples (Excel VLOOKUP WEEK Video #3)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 129595
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm This video is a part of VLookup Week: http://vlookupweek.wordpress.com There...
Ctrl + Shift + Enter: Excel Array Formulas #01: Review Formula Basics (15 Important Examples)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 31269
Download files here: http://people.highline.edu/mgirvin/excelisfun.htm EXCEL ARRAY FORMULAS WORK THE SAME IN ANY VERSION OF EXCEL!!! This video...
LOOKUP function Beginner to Advanced 23 Examples (Excel VLOOKUP WEEK Video #2)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 39556
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm This video is a part of VLookup Week: http://vlookupweek.wordpress.com Learn...
Excel Magic Trick 783: Date Functions & Formulas (17 Examples)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 106237
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. DAY function 2. TEXT Function to get Day spelled out, like "Monday" 3. TEXT...
Vlookup Excel Best
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 550335
Vlookup Function http://www.youtube.com/playlist?list=PL8004DC1D703D348C&feature=plcp This video is an introduction to the Vlookup function in...
What They Don't Teach in Business School about Entrepreneurship
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 402272
Part of 2010 Conference on Entrepreneurship. Description: A group of entrepreneurs talk about what they learned in the trenches that they never...
Excel Data Analysis: Sort, Filter, PivotTable, Formulas (25 Examples): HCC Professional Day 2012
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 334849
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm Learn the basics of Data Analysis at Highline Community College Professional...
Using Excel 2010 - Full Tutorial on the Various Functions
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 72690
This is a full tutorial on the following topics: - Getting started with basic spreadsheet concepts - Performing basic arithmetic calculations...
Improve your efficiency in Excel -- VLOOKUP and Pivot Tables by 7city.com
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 215771
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...
Create a searchable drop down list in Excel
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 96197
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....
Excel for Accounting: Formulas, VLOOKUP & INDEX, PivotTables, Recorded Macros, Charts, Keyboards
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 229509
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...
Tutorial - Excel 2010 - 10 Things you must know
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 1156800
Tutorial explaining 10 of the most common must-know features in Microsoft Excel 2010, Excel is used world-wide and this tutorial shows slightly...
Create a Scrolling Table
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 68408
http://myexcelcharts.blogspot.com How to create a scrolling table that lets your scroll through a range from a larger table.
Excel Magic Trick 781: Three Way Lookup: INDEX and MATCH and Concatenated Ranges & Cells
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 75997
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 Introduction, Explanation, Example in Excel (1 of 2)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 170443
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....
Excel Power Tips: Useful Techniques for Excel Lists, Drop Downs and Data Validation
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 126443
Download sample workbook to follow along at: http://www.launchexcel.com/excel-dropdown-list-data-validation In this 20 minute episode we'll look...
VLOOKUP Between Separate Workbooks and Worksheets in Excel
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 246815
http://www.TeachMsOffice.com This will teach and show you how to use the vlookup function between separate worksheets and workbooks in excel. You...
Office 2010 Class #24: Excel Functions COUNTIF & SUMIF Count and Add with one Condition (Criteria)
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 58448
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
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 140262
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...
IT Skills: Excel - Display two different sets of data in the SAME chart with Secondary Axis
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 87843
http://rikkistips.com. This clip is part of a series of 5 tutorials called "Advanced IT Skills Refreshers for Connoisseurs". During your career...
How to Do a VLOOKUP in Excel - Video Tutorial
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 378874
http://vitamincm.com/excel-vlookup-software-tutorial/ This video shows you how to use MicroSoft Excel's VLOOKUP function to compare values in two...
Excel Magic Trick 913: Select From Drop Down and Pull Data From Different Sheet
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 57298
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm See how to: 1. Select From Drop Down and Pull Data From Different Sheets using...
Ctrl + Shift + Enter: Excel Array Formulas #02: Introduction Array Formulas & Math Array Operation
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 11910
Download files here: http://people.highline.edu/mgirvin/excelisfun.htm EXCEL ARRAY FORMULAS WORK THE SAME IN ANY VERSION OF EXCEL!!! This video...
How to Use Advanced Filters in Excel
Рейтинг Рейтинг Рейтинг Рейтинг Рейтинг 
Просмотров: 169270
In addition to the built-in AutoFilters in Excel, you can create Advanced Filters that allow you to extract unique records or calculate criteria...
Keyboard Shortcuts Everybody Should Know

Просмотров: 190386
Keyboard Shortcuts Everybody Should Know

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

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

Автор Joe Manna (8 месяцев)
Hand down, this is absolutely the *best* VLOOKUP tutorial on the Internet.
Thanks, man! Definitely needed a refresher. 

Автор sensimania (1 месяц)
Please never go away.....you're awesome :)

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

Автор Khalil Medina (7 дней)
Thank you very much. I am so grateful. It is amazing.

Автор Hari Krishna Rao Samineni (9 дней)
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.

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

Автор Beto Mendez (7 месяцев)
Hardcore Excel by someone I follow on G+.

Автор Yang Gao (20 дней)
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!!!

Автор Carlindo Sousa (5 месяцев)
HI there!

Look at this one;) (Cells reference are just an example of course!)

"K15=PROCV($J15;DESLOC($A$8:$I$8;0;0;CONT.VALORES($A:$I)-6);CORRESP($K$14;$A$7:$I$7;0);0)"

Beautiful isn't it?

It's dynamic! We can apply it to any table of contents. Combining 4
functions!

On $J$15 we use a data validation list and the source is
"=DESLOC(A8;0;0;CONT.VALORES($A:$A))"

on $K$14 we use a data validation list with the source is =$A$7:$I$7

Combining that with a user form created on VBA. And we up and running. :)

How about that, what you think?

Best regards,

Carlindo.

PS. I might challenge you soon with a nice problem!

;)

Автор Thais Gomez (14 дней)
Thanks for these videos :) I'm learning so much and I'm making nice tables
and tools for my colleagues at work. Thanks heaps!

Автор Precy Satin (6 месяцев)
This is the simplest and yet informative easy to follow tutorial of
vlookup. By just 2 days of viewing and simultaneously applying it with the
downloadable exercises I can say that I am now fully equipped with vlookup
knowledge. Thank you so much whoever you are! May God Almighty bless you
and your family with good health and wealth. 

Автор Mohamed Farahat (12 дней)
Honestly you are the best 

Автор toleranceiskey truesay (6 месяцев)
oh my God,,,this is best video i have ever come across....free learning
along with downloadable workbook!!!!....Sir u are really helping
loadssssssss of people by your kind effort n help,,,God bless u,,,keep up
the good work

Автор Diego Silva (1 месяц)
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 (1 месяц)
Great Videos! How would you perform a mid function in the case you
presented if numbers or text of differing values?
Thanks!

Автор Sandra Jacqueline Hill (4 месяца)
This is the best tutorial I have ever seen on the internet. Thank you very
much for the help :P

Автор Behzad Nabi (6 месяцев)
fantastic video! thank you so much for taking the time to make this :D

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

Автор gilabaca (5 месяцев)
Thanks Mike for your awesome videos. I wonder why there are 73 people
dislikes this video.

Автор Mark Bibace (5 месяцев)
This guy is Amazing! God bless him. You see all the billionaires
shoveling money to themselves and then you see this guy HELPING people that
can't afford it. You are the BEST!!!!! Um, could we put you in charge of
the healthcare.gov website?

Автор Sean McKinley (6 месяцев)
Sir, I appreciate your videos. I know this takes a lot of work. Thank you.

Автор Dion Garman (3 месяца)
Hey @ExcellsFun, when working through these videos would you suggest we
watch them in their entirety before working through the work books or would
it be better to work through the workbook after each topic section?

Автор kamenqwert (7 месяцев)
Great Stuff. Thank you so much :)

Автор TammyG Wang (19 дней)
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!

Автор jeffrey abrio (5 месяцев)
Bro your the best and thanks a lot this saves me some money. Gob bless you
more!!!

Автор Richard Vicary (6 месяцев)
Your videos are the absolute best, you are a genius in both your knowledge
and your presentation style. Using Choose to generate an array -
absolutely brilliant!

Автор Cristobal Gonzalez (7 месяцев)
man you showed me some time saving tips! thanks

Автор Amarnath Pabbu (6 месяцев)
Good one

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

Автор Ankit Garg (5 месяцев)
Awesome efforts..thanks..do you have any epic video for excel VBA too?

Автор Neda Borisova (6 месяцев)
Your videos are amazing! Thank you so much

Автор keyur chotalia (2 месяца)
Its too good. and explained thoroughly...Thanks for helping 

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

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

Автор bal reddy (7 месяцев)
Thank u so much

Автор Mario W. (6 месяцев)
I've been watching your vids for three nights in a row. Today at work (my
new job) I created a spreadsheet that will dynamically update metrics for
the month and year for two years out. This takes places of the monthly
spreadsheet they've created monthly for the past few years (I believe 5
years). If I don't think of anything better before the time frame expires I
have the option of extending the dates with minimal effort (maybe 30
seconds if that). I feel like a pro!

Автор Erica Clarke (5 месяцев)
where is the workbook, I cant find it on the link.

Автор Kristi Gomez (5 месяцев)
This was very helpful; you saved me a ton of time! Thank you!!!

Автор Deitra Watson (7 месяцев)
Thank you for the VLOOKUP video. This epic video was helpful.

Автор Art by SPG (3 месяца)
Awesome! Thank you!

Автор JungHo Park (29 дней)
Hey! Such a useful video! You saved my time and project!
Thank you sooooooooooooooooooooooo much!

Автор Steve lin (4 месяца)
I was very impressed by this video. It is very clear and easier to
understand. It solved so many issues that I had before. Really great
video!! Thank you very much.

However, I have a small question. When I practiced the last part (dynamic
range, around 1:07:45), the list range in cell D2 did not change as I added
2 names in the table. I did the exact same thing from the instruction in
the video (Including create a table and data validation). Could you advice
me to fix this problem? I am using a Mac Microsoft Excel 2011. 

Автор Dejan Nikolic (5 месяцев)
Hello,
As someone like myself with no experience in excel made table for my small
business this video is excellent.But, there is always that but,as I have
tables with drop down menu to choose what item I need for my quote, also i
would like to have formula that can do pricing once i choose:
from first column, from drop down menu size of the pipe as there are many.
then
from second column drop down menu type of the pipe as there are many.
I have tried to find something similar on your video bu no luck. I have
been on this case for about 40 hours and I think I need help.

Thank you

Автор supersman2000 (2 месяца)
Amazing!!!!!!

Автор Sibulele Mjali (8 месяцев)
Sir, people like you make this world go round! :) This is THE best VLOOKUP
tutorial out there. I cant thank you enough for this video!! 

Автор ARULAMPALAM RAMASTHANAN (2 месяца)
You are really Great.... Million likes for your demo...

Автор Shehzad Patel (8 месяцев)
Hello there sir, i would like to thank you so much on uploading such a
useful video. This video has delivered me insight knwledge about Vlookup
which i didnt knew at all. Honestly i cant thank enough to you. Also your
video is very well presented and explained well. One good thing i like
about watching your video is that you have also provided links to download
workbook which I used to practice on at the same time while watch your
video.. I will surely come back to your other videos...Very effective work.
Thanks, God Bless You....

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

Автор Alex Woodard (4 месяца)
This should be the benchmark for how to do a tutorial on the internet.
Seriously, fantastic work. 

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

URL 
Ссылка 

Поиск Видео

Top Видео

Top 100 >>>

Видео

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