See this:

Goggle Groups

http://tinyurl.com/bes6yx

--
Biff
Microsoft Excel MVP


"Chad Portman" wrote in message
...
I am attempting to use the index function to look at a set of data from
column a to column t down x number of rows. I need this formula to look
for
data in column e and then return the value of the cell in the same row as
the
data it found but from column a. So if the formula was looking through
this
data and found the data in cell E5 it would return the vaule of A5. But
the
data it is looking for will be found on muliptle rows so I need to be able
to
copy this formula down so that if the data exist in cells E5, E7, E10, and
E15 it would display the vaules from A5,A7,A10,and A15.