Excel Magic Trick #5: Data Validation List & VLOOKUP
Loading...
Uploader Comments (ExcelIsFun)
Video Responses
All Comments (100)
-
WoooooooooWW this video really just helped on my homework I was so stumped!
-
@desmondlaugh , You are welcome!
-
@ExcelIsFun . thank you very much i really love your vids and excel I look forward to purchasing your book thx again for the info
-
@desmondlaugh , conver the table or range to a table and the ranges will be dynamic. Try these videos:
Mr Excel & excelisfun Trick 74: Dynamic Range For VLOOKUP & Data Validation List - Table Feature
or
Excel Magic Trick 549: Dynamic Data Validation List Drop-Down OFFSET or Table Feature?
-
Great video quick question please. Is there an easy way to add more cells to the table without having to create the table all over again. I'm trying to add some more info to my tables but I get a N/a in the results column when doing so. So do i need to redo the table each time i get new information. thanks
-
@starfish8910 , if you want to learn Excel it is better to watch the Excel Basics Series and then the Excel Highline Class Series rather than the Excel Magic Trick series because those two show all the tricks in logical order. watch this vid for more info on watch to watch and in waht order:
youtube [dot] com/user/ExcelIsFun
1:43
Excel Magic Trick #4: SUM function Keyboard Trickby ExcelIsFun25,914 views- 3:09
Excel Magic Trick #6: Conditional Formatting for a Rowby ExcelIsFun59,202 views
- 1:54
Excel Magic Trick #7: Clear Formatting Only!by ExcelIsFun21,387 views
- 2:56
Excel Magic Trick # 9: Join 2 Cells into 1by ExcelIsFun31,868 views
- 7:11
Excel Magic Trick 548: Data Validation Drop-Down List In A Cell Same Sheet or Different Sheetby ExcelIsFun34,115 views
- 7:01
Excel: Drop-Downs(Combo Box) and Conditional Formatting (Voice Tutorial)by iProRyan36,705 views
- 4:54
Excel Magic Trick 398: VLOOKUP with Two Lookup Values (IFERROR function also) 2 lookup valuesby ExcelIsFun36,357 views
- 1:35
Excel lookup with multiple conditions! (extended vlookup)by Psychotec15,461 views
- 6:23
VLOOKUP Between Separate Workbooks and Worksheets in Excelby ExcelisHell89,971 views
- 10:50
Vlookup Excel Bestby rdjalayer149,264 views
- 7:58
Excel Lookup Series #1: VLOOKUP Function 1st Exampleby ExcelIsFun317,024 views
- 6:45
Excel Tutorial Using the IF AND and OR Functions Microsoft Training Lesson 27.2by teachucompinc37,062 views
- 5:52
Dynamically Update a Drop Down Menu/List - Data Validation & OFFSET() Functionby ExcelisHell60,080 views
- 3:30
Excel Magic Trick # 3: AVERAGE & Go To Blanksby ExcelIsFun31,833 views
- 3:59
Excel Magic Trick # 159: VLOOKUP Duplicates 1st Columnby ExcelIsFun24,554 views
- 2:58
Excel Magic Trick # 2: Chart Keyboard Trickby ExcelIsFun35,767 views
- 7:36
Excel Magic Trick #22: NORMDIST function for Probabilityby ExcelIsFun27,984 views
- 3:12
Top 10 Essential Keyboard Shortcutsby vidtips21,024 views
- 8:02
Excel Magic Trick #111: Build A Questionnaireby ExcelIsFun25,188 views
- 7:50
Excel Magic Trick #184: Setup Database in Excelby ExcelIsFun99,139 views
wow... it amazing..
carrentalsg 1 week ago
@carrentalsg , I am glad that you like all the videos! You did watch a lot in one day!
ExcelIsFun 1 week ago
I am learning a ridiculous amount of knowledge from videos! Thanks buddy!
johndago1 2 weeks ago
@johndago1 , you are welcome!
ExcelIsFun 2 weeks ago