How to reference another cell based on what row a certian header i

M

mkloosterboer

I would like to have a cell display the same thing as another cell on another
sheet. But the cell I was to reference might change columns often, but it
will always have the same header at the top of the column. So how can I tell
the cell to look at cell 5 for ex. but in the column that says Activity at
the top? remember that the column will change frequently.
 
T

T. Valko

how can I tell the cell to look at cell 5 for ex.
but in the column that says Activity
Click to expand...

Try this...

A1:E1 = column headers, one of which is Activity.

Data in the range A2:E10

=INDEX(A2:E10,5,MATCH("Activity",A1:E1,0))
 

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

Hide columns based on row values 2
Converting a number into a cell reference 2
Referencing cells in consecutive rows 2
Color a cell based on column date and row content 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
Evaluate Multiple Cells for any Value 1
conditional formatting, filtering then copying to another sheet 0
Return cell referance of the first cell that equals a value? 5

Top