7 Ways to Use Vlookup in Excel

Video quality	The size	Download

Information 7 Ways to Use Vlookup in Excel

Title	:	7 Ways to Use Vlookup in Excel
Lasting	:	16.44
Date of publication	:
Views	:	2,4 jt

Very well explained I was searching it on different websites but wasn't able to find it It helped me just few hours ago before exams 😊
Comment from : Jam Eats 😋

Thank You Very Much 💐
Comment from : Happy & Success

thank you sir, brgood explanation
Comment from : Aneesa Syed

What if I want marks from English, Geography, Physics and so on In that case column function is not working Any other way??
Comment from : Sonu Pandey

In ms excel, Sheet1 we have header (index type, onsitoffshore_flage, account name, sow number, emp_id, BHC exit data Q2) and we have another sheet(2) we have header (index type, onsitoffshore_flage, account name, sow number, emp_id) Now in sheet1 we have fill total count of emp_id in BHC exit data Q2 column of emp_id count in sheet(2) we need to match sow numbers of 2column number in Sheet1 & sheet(2)brNote: in Sheet1 we gave sow numbers in 5digit and in Sheet(2) we have sow numbers with 15 digits Now we need to find match 5 digit number within 1 5digit numbers and find count of emp_id in each matching 4columns headers:- rows count in BHC exit data Q2 column? How to do this which formula to be used?
Comment from : Saravanan Santhosh

How to use Vlookup on filtered data
Comment from : Aju Louis

Thanks to xlookup now…vlookup the worst excel function I have ever seen
Comment from : Kanhaiya Shaha

So good
Comment from : musaazi joseph

Sir where are you? We are missing you
Comment from : GODZILLA EDITZ⚡

Thanks a lot for this wonderful explanation!brbr@AccountingSkillsTraining
Comment from : آموزش مهارت حسابداری /ابراهیم حسنی فرد

Thank you!
Comment from : Wilbryan Locreda

Thank you
Comment from : Mannoj Nair

I have subscribe🎉
Comment from : Vibs Vibs

Wow ur great job🎉❤
Comment from : Vibs Vibs

I tried on my computer but couldn't do it I need ur assistant
Comment from : Rashid Alhassan

Good information sir
Comment from : Appanna Dhoni

Thank u so much
Comment from : Harsh shah

Could have used MATCH formula instead of column, if the subjects name wouldn't be in sequence
Comment from : Excel Ka Gyan

Very helpfull Big Tx
Comment from : Agustian Wijaya

Excellent
Comment from : Anandrajsinh Jadeja

wonderful
Comment from : Creative Amrit

im a beginner, I want to vlook up the first name on the other excel sheet, but when i use vlook up it gives me the very last name and not the first name i try other column but always give me the last info and not the first one i want can somebody tell whats the probem?
Comment from : Argo DiCaprio

The dumbest explaination i have seen
Comment from : Sports PuliHora

Sir very nice
Comment from : Vandana Jannu

Great video sir very thankfull now i know the Vloopup functions are very powerfull 😊
Comment from : Heezukaa

the mention of absolute values using F4 solved my problem, thank you!
Comment from : stardomee

If i want to check the Top 4 marks ten
Comment from : Trimurti Saxena

Thanks 🙏
Comment from : Satendra Nath

Use hindi more powerful
Comment from : VIPIN CHAUDHARY

how can you copy that formula and drag it down the rest of the list you have to find out the qualifications? when I click and drag often the table array gets changed? thanks for the view by the way!
Comment from : Cbl

HOW To find minimum and maximum value in the whole table with respective subject and name
Comment from : Arul Kavi

IT IS NICELY EXPLAINED BUT I AM NOT CLEAR WHY WE HAVE TO ADD ZERO AFTER COLUMN NUMBER IS THAT NAME IS EXACT TO IMPLY OR WHATbr?
Comment from : Arul Kavi

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 🙏
Comment from : Zareen Shonaa

youtube/byXuAgSGgt8
Comment from : Zeeshan Skills Studio

So easy thankyou so much❤🎉
Comment from : Prashant Chauhan

Sir kindly tell me how do you copy vlookp format what is the key I tried but I didn't get kindly tell me
Comment from : しᥑνᥑɳყᥑ 297

1:39 normal lookupbr6:20 lookup from different sheetbr7:33 look up from a different workbookbr8:47 multiple vlookup
Comment from : Cherry H

Helped a lotbrHow to find which student got least value if we do not know neither
Comment from : Ram Srikar

Thank you, I clear my dout in multiple values🙏
Comment from : Emebet Kebede Wakie

Thankyou🎉
Comment from : Samarth SHosamani

9:28 personal
Comment from : Rohit Thakur

How to create inventory sheets To use formulas & created to any sheets in the formulas plz 😅
Comment from : Sfreak Musfaozil

#5 is very important functions THANK YOU SO MUCH!!!!!
Comment from : Yan Wang

Thank u so much sir its so helpful 👍
Comment from : Noorin Shaik

there is no practice file, pls provide practice file
Comment from : Sudesh madhusudan

Very well explained
Comment from : Samir Mistry

Best tutorial I've seen Thanks
Comment from : Lab Adventures Technologies

Vlookup multiple values at once brbrThis videos is not visible and formula f4 something u put it there please make this video one more time should visible and formula should be clear
Comment from : shambhu m

good
Comment from : Ahmad Sheikh

Excellent teaching way specially for beginner thanks
Comment from : Nauman Fakharr

hiMr Guru I appreciate your efforts pls consider this data copy by VLOOKUP or any other system and I want take one timebrtwo copies how it possible and how I send the file I am sure haven't meet this task pls send the email address
Comment from : MOHAMAD SIDDEEK

Sir video quality is not so clear please next time make it clear quality video thank you
Comment from : abhilash rao

Great Video I have seen 10 more videos but at the end I was able to perform my assignment after watching this video only
Comment from : Talha Hussain

Thank you so much
Comment from : ram arjun

Thank you 😊
Comment from : PHAN Rathna

Thanks " wwwyoutubecom/@GuruJii " it worked well for me during my data analysis task using MS Excel
Comment from : Harshit Keshari

16:19 I never got your practice files ever
Comment from : TheLionWantstoRoar!

Very nice video thank you so much 😀
Comment from : shristi kalra

This is probably the easiest explanation of vlookup I have ever come across till now
Comment from : Ashish H

Can u help me with formula for open and closed
Comment from : Algeshwari Thevar

Thank you sir
Comment from : Deepak R

I am trying same your vedio procedure but it's not working
Comment from : Ziaullah Khan

nice
Comment from : Vishnu Rupnar

Good,Crystal clear explanation! Kindly share Pivot table link same like as Thanks
Comment from : Ganesh Babu

Pls translate Tamil
Comment from : Siva Sivakumar

Hia doubtwhy should u use vlookup for finding lowest valueu can instead use min() directly
Comment from : Dinu AD

Aids voice
Comment from : zuhair shahid

Great video, I cannot download the file, I get an error that it is not available
Comment from : karakol86

This is awesome
Comment from : JustBroken

My f4 key prints, it doesn't give me an absolute sign, do you have any suggestions, please?
Comment from : govardhani y

It helped a lot Thank you so much 😊
Comment from : Marsh Mallow

Thank you You saved my lots of time God bless you
Comment from : Shankru Kulkarni

While using the formula, i am unable to use F4 Also, if am adding $ manually It is not giving me right data Each row showing one result only from the aray and rest it is showing NA
Comment from : Puneet Arora

don't mind mebrbr1:44 normal vlookupbr6:29 vlookup from different sheetbr8:00 vlookup from different workbookbr9:25 copy vlookup formulabr11:46 vlookup multiple values at oncebr14:20 vlookup smallest valuebr15:25 vlookup largest value
Comment from : Maryam Iffah Abdul Hamid