If you copy the cell with the VLOOKUP formula down, it will replicate the formula in every cell. ... Choose "Sort sheet by column A -> Z." Enter your formula as you normally would.

For example, if you copy a VLOOKUP formula from cell C2 to cell C3, the relative references in the formula will shift down one row, ensuring that the lookup value and table array references remain ...