Excel - Formula to link column title

  • Thread starter Thread starter ajlove20
  • Start date Start date
A

ajlove20

Hi,

I have created a new sheet in a workbook. I want to be able to link
column to the new sheet by the title of it. For example:

I have 5 columns on the original worksheet

Name Age School Grade Pass/Fail

I want to be able to link "Age" to the new sheet, but I just want t
do it by the title (Age) and not the column letter (B).

Any input on this would be appreciated. Thank you in advance.

a
 
Hi
maybe something like
=INDEX('sheet1'!A1:E10,10,MATCH("Age",'sheet1'!A1:E1,0))

to get the value from the 10th row under the 'Age' column
 
Assign an name to column B. You can do this by selecting
the column and then typing AGE in the cell reference at
the top left of your screen. Hope this is what you were
looking for
 
Hi,

Thank you. It worked fine, but is there a way i can get the all th
rows or do i have to create one for each row.

a
 
Back
Top