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...
Dynamic Charts in Excel - The Easy Way
Tutorial: How to create dynamic charts that update automatically when new data is added to Excel. ...
Convert Numbers into True and False in Excel
Tutorial: How to convert numbers into the TRUE and FALSE Boolean values in Excel. This is very impor...



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.