Gabrielle_erre
New Member
- Joined
- Jan 3, 2019
- Messages
- 21
Hi, I would like to know if any of you needed the index function for dynamic column... I have the following function and I can't figure out how to make it work with Tabelle2!F column wich is Tabelle2![Name] column dynamic... in F1 I have the name of the column.
Any reccomandations replacing Tabelle2!$F$2:Tabelle2!F156 with the dynamic column's name?
=IFERROR(INDEX(Tabelle2!$F$2:Tabelle2!F156, MATCH(0,INDEX(COUNTIF($D$1:D1,Tabelle2!$F$2:Tabelle2!F156),0),0)),"")
Thank's in advance!
Kindly,
Gabrielle
Any reccomandations replacing Tabelle2!$F$2:Tabelle2!F156 with the dynamic column's name?

=IFERROR(INDEX(Tabelle2!$F$2:Tabelle2!F156, MATCH(0,INDEX(COUNTIF($D$1:D1,Tabelle2!$F$2:Tabelle2!F156),0),0)),"")
Thank's in advance!
Kindly,
Gabrielle
Last edited: