Are you saying that you don't know how to use Excel help?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Ed Davis" wrote in message
...
Sorry I do not understand what I need to do here.

Thanks

"Don Guillett" wrote in message
...
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?