Feb 17 2020 04:32 AM
Please tell me why it keepts telling me I have an invalid reference in my matrix formula.
I am looking for a specific last name in A in the other file that schould be the same as Y8 where the user should type in the name it is supposed to search for. The number it is supposed to copy is in B in the other file. That number should end up in X10 of my file.
It keeps telling me I have an invalid reference. Please help!
[=WENNFEHLER(INDEX('[Widmungen Referenz.xlsx]Tabelle1'!B:B;KKLEINSTE(WENN('[Widmungen Referenz.xlsx]Tabelle1'!$A$1:$A$104=Y8;ZEILE($1:$104));ZEILE(A1)));"")] |
Feb 17 2020 06:29 AM