BanMeThuot
New Member
- Joined
- Dec 1, 2009
- Messages
- 14
I am using EXCEL 2010. If I use table nomenclature in a formula and copy it into the columns to the right, the reference is relative and thus, changes as I copy to each column. Is there a way to make the table nomenclature reference absolute?
I am using the following formula (it works and I can live with it):
=INDEX(Demo11[Birthdate],MATCH($E7,Demo2011$T$3:$T$98,0))
However, I would like to use this formula if I could keep Demo11[student] absolute:
=INDEX(Demo11[Birthdate],MATCH($E7,Demo11[Student],0))
Thank you
I am using the following formula (it works and I can live with it):
=INDEX(Demo11[Birthdate],MATCH($E7,Demo2011$T$3:$T$98,0))
However, I would like to use this formula if I could keep Demo11[student] absolute:
=INDEX(Demo11[Birthdate],MATCH($E7,Demo11[Student],0))
Thank you