Look in the help index for MATCH. Then look for INDEX and nest your match
within the index.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ed Davis" wrote in message
...
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?