C
Chad Portman
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.
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.