ReePrime
Blog DMC
Dueling Excel - Dynamic Validation VLOOKUP: #1379

Hosted by Dailymotion. For legal issues report at the Copyright Center, report us on DMC, or use the Instant Removal tool.

Dueling Excel - Dynamic Validation VLOOKUP: #1379

B
Bill Jelen

1 Views • Apr 08, 2011

Description

Today's Dueling Podcast asks: "Can there be Dynamic Ranges for VLOOKUP and Data Validation List for an Invoice?" In Episode #1379, Mike "ExcelIsFun" Girvin and Bill "MrExcel" Jelen look at using Table Nomenclature in Validation and in VLOOKUP.

Keywords & Tags

#Excel #business #accounting #spreadsheets #tutorial #technology #MrExcel #Table #Validation #VLOOKUP #Data #List

More from User

02:34

MrExcel's Learn Excel #976 - Default Comment

Bill Jelen

03:19

Learn Excel 2010 - "Date Next to a Yes" #1474

Bill Jelen

07:51

Dueling Excel - "Rank Ties by Weight" #1473

Bill Jelen

03:39

Learn Excel 2010 – “Wrap Cells and Resize" #1472

Bill Jelen

02:08

Learn Excel 2010 - "Random with No Repeats" #1471

Bill Jelen

06:30

Learn Excel - "Copy Total to Weeks Macro": #1470

Bill Jelen

Related Videos

09:14

How to Use Vlookup to Merge Spreadsheet Data - Match Data in Google Spreadsheets and Excel

Alonza Darrick

09:29

Excel Tips: Speed Up Your Data Entry - Data Validation VLOOKUP Format As Table Date Stamp

Ngọc Phan Trương Bá

01:26

How to Excel Delete Remove Duplicates and Duplicate Cells Data from Multiple Excel Spreadsheets

HotHotSoftware1

08:47

9 vlookup in Data Validation

Tree School Pk

00:57

Professional Excel Templates And Spreadsheets

CFOTemplates

00:42

MS Excel Setting Passwords in Existing Spreadsheets

Smoke Studios