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.
You are welcome!
ExcelIsFun 2 years ago
thks very helpfull
Regards from Mexico
mossbach 2 years ago