Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Dueling Excel - Dynamic Validation VLOOKUP: #1379

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
867 views
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Apr 8, 2011

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.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (3)

Sign In or Sign Up now to post a comment!
  • Wooo Together at last! The two best in excel on ONE VIDEO! i cant type fast enough, cause im trying to get to the video!! thanks guys! You two are the greatEst!

  • fantastic video....I did not get the reason for having the formul =if(c5="","",vlookup.... couldn't it be straight being =vlookup(

  • very cool. i like how Bill actually pulled off a wardrobe change from the beginning to the end of the podcast.

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more