That worked, but I can't manage to VLOOKUP that value to pull up column 2 from another tab in the workbook. I formatted the cells the same and everything is sorted but it still returns #N/A.