Excel Forum
Similar Content
Filter Data in Excel to Display Results that Contain 1 of 2 Possible Values - AutoFilter
Macro: This Excel macro filters data in Excel to display results that contain 1 of 2 possible val...
Ignore Blanks in a Data Validation List in Excel
Tutorial: I will show you 3 ways to remove the blanks from a Data Validation dropdown menu in Excel...
Formula to Get the Last Value from a List in Excel
Tutorial: Formulas that you can use to get the value of the last non-empty cell in a range in Excel...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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


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.





Got a Question? Ask it Here in the Forum.