VLookUp - How To Extract Data From an Excel Spreadsheet Given Customer ID Number

  Рет қаралды 49,389

The Organic Chemistry Tutor

The Organic Chemistry Tutor

2 жыл бұрын

This excel video tutorial explains how to use the VLookUp function to extract data from a spreadsheet using a Customer ID number.
Excel Tutorial For Beginners: • Excel Tutorial For Beg...
Top 30 Excel Tips & Shortcuts:
• Top 30 Excel 2016 Tips...
_________________________________________
How To Calculate The Total Hours Worked:
• How To Calculate The T...
How To Make a Time-Sheet In Excel:
• How To Make a Simple T...
How To Calculate Loan Payments In Excel:
• How To Calculate Loan ...
How To Create an Amortization Table:
• How To Create an Amort...
Excel - Business Account Ledger:
• Business Account Ledge...
________________________________________
How To Look Up Customer Data In Excel:
• VLookUp - How To Extra...
Excel Vlookup Function:
• How To Use The VlookUp...
How To Create a Data Entry Form In Excel:
• How To Create a Data E...
Multiple Dependent Drop Down Lists:
• How To Create Multiple...
How To Show & Hide Formulas:
• How To Show and Hide F...
______________________________________
KZbin Channel Growth Accelerator:
/ youtubechannelgrowthac...
Final Exams and Video Playlists:
www.video-tutor.net/
Full-Length Math & Science Videos:
/ collections

Пікірлер: 29
@Eselkay1989
@Eselkay1989 Жыл бұрын
Finally, it's here. Thank you bro. The only tutorial which is straight-forward and fruitful. Many tutorials.... blah, blah but useless. Thank you once again bro. Keep helping.
@njmanga617
@njmanga617 2 жыл бұрын
Thank you for the video great explanation 👍
@Dumb_ForkTp
@Dumb_ForkTp 9 ай бұрын
Thank you so much saved me a lot of time and effort
@ackszn
@ackszn 2 жыл бұрын
You're amazing bro🙌🏾
@Vutha962
@Vutha962 3 ай бұрын
Thank you so much, you helped alot
@H.ky.
@H.ky. 2 жыл бұрын
Simple and Straight to the point.
@user-tj7wz6ew5f
@user-tj7wz6ew5f 2 ай бұрын
very informative thank you
@okeeArafat
@okeeArafat 8 ай бұрын
❤❤🎉 you saved my life by saving my time.
@Agbah_K_Lawson
@Agbah_K_Lawson 2 жыл бұрын
I am leaving this comment here so that when ever someone likes it I will use this video as my revision
@hamzamemon3572
@hamzamemon3572 2 жыл бұрын
Finally you have entered my realm 👏🏽👏🏽👏🏽
@stephennutsugahdoe4931
@stephennutsugahdoe4931 2 жыл бұрын
This is very good. I have a class on this tomorrow
@excellearners7976
@excellearners7976 4 ай бұрын
THNX
@JbTheRider
@JbTheRider Жыл бұрын
Hey you! Thank you, you unlocked another door of opportunity for me, you the best! 🤗
@martiain07poison007
@martiain07poison007 7 ай бұрын
2:03
@meganstrydom8517
@meganstrydom8517 11 ай бұрын
Hi there. How can one have have the email address to be functional when you use vlookup function,meaning when you look it up and click on it then it will take you directly to the email? Thank you
@mexicanmapper5064
@mexicanmapper5064 8 ай бұрын
Now how do i lookup an ID from first & last name??
@wkppp4732
@wkppp4732 2 жыл бұрын
Thanks bro!
@UnathiGX
@UnathiGX 2 жыл бұрын
Very Organic!
@troynacianceno369
@troynacianceno369 9 ай бұрын
What if the data is on another sheet?
@yasinshaikh1574
@yasinshaikh1574 11 ай бұрын
Facing issues with the date cell..it not reflecting
@JCEurovisionFan1996
@JCEurovisionFan1996 2 жыл бұрын
Can you do the SORT, FILTER, SORTBY, XLOOKUP, and UNIQUE?
@cdotmag
@cdotmag 6 ай бұрын
how would I do this with a dropdown instead of typing out the customer Id number each time?
@diabetes2remedies
@diabetes2remedies Жыл бұрын
how may I get a list of customers that live in one state(what ever i choose) so i can get the email of each one ,and creating another list just for that group?
@Jackie-vr3yy
@Jackie-vr3yy Жыл бұрын
Make a video about how to calculate in payslip bro
@austinb3560
@austinb3560 2 жыл бұрын
Funny I’m literally just taking a bus stat class and we’re apparently gonna be doing this. I doubt I’ll even pass.
@Cipher6i8
@Cipher6i8 2 жыл бұрын
Positive vibes, bro. Positive vibes. Bus stat is easy. You'll be using a lot of excell to do calculations, and it just requires practice. You got this!!!
@bradleythirumurthi
@bradleythirumurthi 10 ай бұрын
😂 G14 Classified
@urekmazino4427
@urekmazino4427 Жыл бұрын
DÜŞEYARA(C3;A4:J99999;3)
@abdulrahimjalloh8469
@abdulrahimjalloh8469 2 жыл бұрын
Literarily learned about VLOOKUP() this morning 😂👌
Extract Data to Separate Sheets the Right Way!
8:34
MyOnlineTrainingHub
Рет қаралды 168 М.
Amazing weight loss transformation !! 😱😱
00:24
Tibo InShape
Рет қаралды 67 МЛН
World’s Largest Jello Pool
01:00
Mark Rober
Рет қаралды 113 МЛН
SPILLED CHOCKY MILK PRANK ON BROTHER 😂 #shorts
00:12
Savage Vlogs
Рет қаралды 10 МЛН
Excel VLOOKUP With Multiple Workbooks
12:14
Maxwell Stringham
Рет қаралды 3,4 МЛН
Top 10 Most Important Excel Formulas - Made Easy!
27:19
The Organic Chemistry Tutor
Рет қаралды 7 МЛН
How to Extract Data from a Spreadsheet using VLOOKUP, MATCH and INDEX
15:54
Tuts+ Computer Skills
Рет қаралды 5 МЛН
Creating Easy Data Entry Forms in Excel
9:52
Technology for Teachers and Students
Рет қаралды 3 МЛН
Stop using VLOOKUP in Excel. Switch to INDEX MATCH
11:05
Excel Level Up
Рет қаралды 2,3 МЛН
Vlookup vs The Lookup Function Explained! - Excel
10:13
The Organic Chemistry Tutor
Рет қаралды 36 М.
How to Use VLOOKUP in Excel (free file included)
15:15
Leila Gharani
Рет қаралды 174 М.
Vlookup Function in Excel for Beginners
11:35
Teacher's Tech
Рет қаралды 1,6 МЛН
Amazing weight loss transformation !! 😱😱
00:24
Tibo InShape
Рет қаралды 67 МЛН