Forum Discussion
Number of columns using match
Hi, Is there a maximum value for column number using match? I have this formula: {=INDEX(t_teamleder;MATCH(t_montasje[AnsattID];t_teamleder[AnsattID];0);MATCH(t_montasje[#Topptekster];t_teamled...
Geir, what do you mean under "stop working" - it returns an error or what?
hi @serSergeiBaklan It returns nothing. The last column with value (and the function) is Man5 (column 66). After that it is empty. I have double checked that the column name Tir5 is a match.
But I think I solved it. Deleted the function, and pasted it in again, then it worked. Almost as the source table has been expanded, and that expansion was not recohnized by the formula.
- Geir
Geir, thank you for the update. Glad to know you sorted this out.
