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_teamleder[#Topptekster];0))}
The first match find the row by comparing Employee-ID, the second match find column by comparing table headers.
It Works find, until it gets to column 67, there it stops. (Tir5)
The Teamleader-table:
The Montasje table:
The result from the function:
If I use a simple Index, it works:
=INDEX(t_teamleder;6;67)
Best Regards
- Geir
3 Replies
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.
