Excel Tutorial - Lookup List
Loading...
Loading...
8,354
Loading...
6:21
Excel Tutorial, Lookup Functions (2 of 2)by FinneyLearning5,421 views- 10:50
Vlookup Excel Bestby rdjalayer152,865 views
- 2:47
Excel - Using a combobox Tutorial- Cell Linkby akphidelt102,564 views
- 7:25
Excel Tutorial, Pivot Tables (3 of 3)by FinneyLearning87,499 views
- 5:40
Excel Tutorial, Lookup Functions (1 of 2)by FinneyLearning12,689 views
- 5:41
excel malayalam tutorial part 20by mayavyi3,657 views
- 1:58
Drop Down List in Excelby contextures164,805 views
- 5:52
Dynamically Update a Drop Down Menu/List - Data Validation & OFFSET() Functionby ExcelisHell60,931 views
- 6:15
Excel Named Rangeby claytonLock7,597 views
- 37 videosMs Excel
- 9:32
Excel Tutorial - Introductionby dakinane19,135 views
- 3:47
Add Combo Box Drop Down List to Excel Worksheetby contextures45,378 views
- 4:19
Microsoft Excel #04: Excel as a Databaseby freetutorials450,335 views
- 3:57
Excel Tutorial, Using Operatorsby FinneyLearning1,368 views
- 6:47
Microsoft Excel VLOOKUP Tutorialby 599CD381,182 views
- 4:02
Excel Tutorial, Lookup Functionsby FinneyLearning3,073 views
- 5:27
Excel Tutorial, Subtotals (1 of 2)by FinneyLearning5,398 views
- 2:08
E1.7 VLOOKUP across two worksheetsby Firchild217,536 views
- 3:04
Excel Tutorial, Home, End, and GoTo Commandby FinneyLearning1,418 views
- 4:13
Excel Lookup Series #8: MATCH Functionby ExcelIsFun70,456 views
- 2:57
Excel Tutorial: Find Missing Numbersby videoturo17,486 views
Hi Matt,
A very clear explaination of using lookup but does not explain why named ranges are useful.
Use named ranges to avoid trying to remember what a2:a11 really is.
One follow-on question:
Is there any way to filter the drop-down list? I may want thousands of drop-down items but scrolling to item B will be tedious, let alone Z.
mrtibbs2007 3 years ago
Have you got an idea how to show on the list additional description? Value of selected item from the list still have to be the same. Ie you can pick up from list Chicken (Remember - chicken is horrible) but the value still will be Chicken. Is this possible?
szpakers 3 years ago