VLOOKUP: Vertical Lookup in Excel

Excel will return the sales rep name: To quickly copy the formula down to all of your rows of data, double click the fill handle (the square dot) in the lower right corner of cell F2. Excel will quickly copy the formula and you will have filled in all of the rep names. 2. #N/A values indicate missing values in the lookup table ................
................