7 Ways to Use Vlookup in Excel

preview_player
Показать описание
7 Ways to Use Vlookup in Excel are
1 Normal Vlookup
2 Vlookup From Different Sheet
3 Vlookup From Different Workbook
4 Copy Vlookup Formula
5 Vlookup Multiple Values At Once
6 Vlookup Smallest Value
7 Vlookup Largest Value

** Useful Excel formulas and Functions **
10 Most Used Formulas MS Excel

Learn Basic Excel Skills For Beginners || Part 1

10 Most Used Excel Formula
**Most Imporant Excel Formuls Tutorials**

Learn Vlookup Formula For Beginners in Excel

5 Excel Questions Asked in Job Interviews

Create Speedometer Chart In Excel

Learn the Basic of Excel for Beginners || Part 2

Create Pareto Chart In Excel

How to Create Dashboard in Excel

Excel Interview Questions & Answers
Рекомендации по теме
Комментарии
Автор

This is first video, where I could understand how to use vlookup. I watched so many videos, I wasn’t able to understand it.
Thank you so much.

sumangaddu
Автор

don't mind me

1:44 normal vlookup
6:29 vlookup from different sheet
8:00 vlookup from different workbook
9:25 copy vlookup formula
11:46 vlookup multiple values at once
14:20 vlookup smallest value
15:25 vlookup largest value

maryamiffahabdulhamid
Автор

Vlookup has been explained in the easiest way following step by step basis. The Teacher is one of the best communicators I have come across. Kind Regards.

xaviervenancious
Автор

Just at 3:42 minutes and I am liking the way of explaining. It is like a friend sitting next and explaining. :)

frankyfernandes
Автор

how i learned so much from this tutorial! keep posting informative vids in esp. excel.

harrietdomingo
Автор

I only use Excel for my business to make a cash book and an attendance tracker for my students so I'm not that good at it. I needed to use this formal and this video has been the only one that worked for me. Thank you very much!

DogaF
Автор

Thank you... You saved my lots of time.. God bless you

shankrukulkarni
Автор

Just woww, , this video made my day because I was a bit confused in Vlookup formula methods but now it's very clear, it's a very very helpful video to understand Vlookup in a very easy way thanks a lot 🙏

zareenshonaa
Автор

Thank you sir.. I trying to learn from so long time... Refered so many vedioes.. But it will not help me... I seen your vedio... I clear understand and I tried... It's really helpful... Thanks a lot sir

Reshma_S_Reshu
Автор

Nafaah Osman from Ghana. Orderly and systematic presentation, you are indeed a GURU for you have made my day

osmannafaah
Автор

Great stuff! The best video ever on Vlookup. You made it look so simple, I learnt all 7 ways in just one view. Thanks a lot

RamaChandraChessAcademy
Автор

This video is simple and straight to the point. Thank you.

thebesttechnical
Автор

Ohh yes this is the video I hv been searching. Very helpful

dimpalsarma
Автор

I really valued your videos, I have been searching for multiple vlookups function, now I have cleared it from your video. Thanks Bro.

noboboro
Автор

Great Video. I have seen 10 more videos but at the end I was able to perform my assignment after watching this video only.

talhahussain
Автор

Many thanks for this video. I had an interview and this has really helped me.

vinithageorge
Автор

One of the best vlook video on internet.. all ways described very precisely.

sanyamjain
Автор

This is probably the easiest explanation of vlookup I have ever come across till now.

ashishh
Автор

Usually i dnt subscribe anyone but your efforts made me subscribe your channel thank you for the video.

II-dohf
Автор

at 12:24

Rather than ColumnS($Q$3:R3), if we just type COLUMN(R3), that will also do the job, I suppose. I have tried it many times and it has worked well but I am not sure whether there are any disadvantages of this method.

When you try this method, make sure that you use the Column function (without S at the end), not the ColumnS funtion.

I should also note that it is an amazing video. I particularly liked vlookup from a different workbook. That is something that I have never thought of before. Thanks indeed.

emrullahtan