Index function

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Function to Return a Date Value Q 4
Insert Index into a Table 1
Payment calculation 1
index function 1
Index Match function for lookup HELP 5
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Hide columns based on row values 2
Create an array of separate cells 3

Top