Excel Forum



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.