Does anyone know how I can get information from a range of cells more than
nine rows?
Example
If a name shows up within a range from range D9 through D20 then enter
whatever
is in the cell in column F but the same row as the name shows up on?