Просмотров: 25,572,418
Добавлено: 1 месяц
Длительность: 3:56

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

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

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


Просмотров: 25572418
https://youtube.com/devicesupport http://m.youtube.com


Автор ExcelIsFun (1 год)
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
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)

How To Use Excel VLOOKUP Function
Learn Excel VLOOKUP Function
VLOOKUP made easy
Excel VLOOKUP Function

Автор Joyousj (17 дней)
OMG just stumbled on your video..THAAAAANK YOOOOU! THIS right here, just
saved my butt! Whew. Going to make my job a lot easier! Be blessed! 

Автор Michael Pasqua (1 месяц)
Seriously, this is the most helpful video I've ever watched.

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

Автор Gareth Reagan (6 дней)
Regarding using CHOOSE to work with multiple tables, if there are many
tables to choose from would it be more efficient to name the ranges of each
table then use INDIRECT in the VLOOKUP second argument to build the name of
the correct table and then return the array of data? e.g. Name data range
in the 3 tables tblABC, tblEDR and tblEDS, then use
VLOOKUP(B4,INDIRECT("tbl"&A4),2) in your example 17.

Автор Tony Valadez (12 дней)
You helped me nail a job interview. Thank you!!!!

Автор Israel Galvez (2 месяца)
i cant open the workbook =/ its not working, says error

Автор Ali Hassan (1 месяц)
Can anybody directly send me the link from where I can get that workbook
downloaded. I'd greatly appreciate that. 

Автор Handoko Liam Rianto (3 дня)
Hi, I just realized all this time I've been using the wrong lookup
function, I keep using LookUP() function for a vertical table everytime I
have new values I have to update the table in alphabetical order. However
with Vlookup I dont' have too. Any disadvantage of Vlookup I need to be
aware of? Thanks.

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

Автор L'Ranj V (1 месяц)
you are awesome! Thank you!

Автор Cheryl Clarke (11 дней)
Thank you!!!!!! This is so clear and to the point...savior!

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

Автор Raquel Catalan (1 месяц)
I have tried to pull the file and I could not find it.

Автор Zaheer Abbas (1 месяц)
Thank You so much for such kind of quality training video. God Bless You.

Автор Abdul Jaleel Uae (1 месяц)

Автор Ganesh Parab (2 месяца)

Автор Sam Diboma (1 месяц)
Please how can I merge 12 excel sheets containing data of 50 countries
spread over 30 years using the VLOOKUP function (the data are contained in
one excel file)

Автор Jamie Bates (15 дней)
Great video. VERY, VERY helpful. Question (44.54 min) why did you use -1
in the SEARCH function?

Автор Marie clark (1 месяц)

Автор Marcus Anthony Francisco (3 месяца)
Vlookup Training Advance

Автор shiva prakash (2 месяца)

Автор helen gatlin (24 дня)
very good vlookup tutorial, and a long one. Spent some very valuable time
on this. Thank you very much for sharing this wonderful video and workbook
with us.

Автор cosmel villalobos (3 месяца)
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!!!

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

Автор Jessica To (2 месяца)
I am interested learning about vlookup, Hlookup and pivot table. Do you
have any courses available and how can i get in contact with you?

Автор Pearly Sunitha Samuel (2 месяца)
Thank you so much. So much information for free ! Thanks for all your
efforts God bless you abundantly

Автор Sherry Thompson (2 месяца)
I love these videos, but I can't seem to find the help I need with my
Vlookup. I have a list of accounts all starting with the same prefix, and
different suffixes (ie: 6000-100, 6000-215, 6000-350, etc.). I need to be
able to do a vlookup so that it returns the values if they contain the
prefix I'm looking for. I've done the vlookup using the prefix and the
wildcard, but if I repeat the formula down, it is just returning the first
value in the list (6000-100). How can I get it to return the values that
are listed with the desired prefix? I cannot separate the column so I have
to be able to read it as is. Any help/advice is GREATLY appreciated!!

Автор Jose Lopez (4 месяца)

Автор Marcus Anthony Francisco (2 месяца)

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

Автор Chinese Hacker (3 месяца)
This was awesome!!

Автор Shahriar Arif (3 месяца)
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? 

Автор Learn Excel Formulas (1 месяц)
Awesome tutorial on Vlookup, thanks for putting this together!

Автор Una Sana (3 месяца)
where can i download this file.? I really can't find it!
Thanks and yeah great stuff here.

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

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

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

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

Автор Dritan Naum (8 месяцев)
VLOOKUP Function Beginner to Advanced 26 Examples…:

Автор Shambhu Patil (4 месяца)

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

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

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

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

It's in hungarian, I believe that the exact version in english is:
It's ugly as hell but believe it or not it's actually working!

Love ya!

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

Автор ssp1r1t (8 дней)
At the "Two Way Lookup" is it ok to use this formula
Instead of the VLOOKUP

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

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

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


Поиск Видео

Top Видео

Top 100 >>>


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