Forum

Notifications
Clear all

Relative Reference to Table Header Column not working

2 Posts
2 Users
0 Reactions
71 Views
(@carsto)
Posts: 1
New Member
Topic starter
 

The following ARRAY formula WORKS but the Relative Reference Table_Contact[M_5] doesn't change when dragged

 

{=IFERROR(INDEX(Table_Contact[[Full Name]:[Full Name]],

MATCH(1,(Table_Contact[M_5]="X")*(Table_Contact[[Row ID]:[Row ID]]=SMALL(IF(Table_Contact[M_5]="X",Table_Contact[[Row ID]:[Row ID]]),   ROW()-ROW(Table_DV[#Headers])   )),0)), "") }

 
Posted : 22/09/2018 1:41 pm
(@fravis)
Posts: 337
Reputable Member
 

Welcome here on the Forum Carsto!

Oh what would it help if you give your Excel example sheet with the question. Is that possible for you?

Frans

 
Posted : 23/09/2018 10:36 am
Share: