Excel Magic Trick #147: Dynamic List from Table #2

Loading...

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

Uploaded by on Nov 19, 2008

See how to how to extract records from standard table and put a record in a column. See how to use the functions; VLOOKUP, IF, ROWS functions.

See data validation list. Learn about how VLOOKUP sees empty cells as zeroes and learn how to use a formula to put a blank in a cell so that VLOOKUP uses a blank instead of a zero from an empty cell.
ALSO: SEE AMAZING BLANK FORMULA TRICK FOR THE VLOOKUP FUNCTION. See Go To Blanks, then formula for VLOOKUP blanks.

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (2)

Sign In or Sign Up now to post a comment!
  • You are welcome!

  • thks  very helpfull

    Regards from Mexico

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