Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
11
Views
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
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
