Forum Discussion
jan970
Oct 01, 2024Copper Contributor
Vertical search of multiple variables has to return a different value depending column data found
Hello, I'm doing a search to find the % that belongs to a team ( fe Anderlecht) coupled to a matchday (fe 1) (table 1 => looking to fill cell N/B marked in yellow) The data comes out of sheet 2...
- Oct 01, 2024
jan970
Oct 01, 2024Copper Contributor
I get an error when entering
=X.lookup(A3;Speeldagen!$B$2:$B$9;Speeldagen!$C$2:$C$9;X.lookup(A3;Speeldagen!$E$2:$E$9;Speeldagen!$F$2:$F$9;0;0;1);0;1)
=X.lookup(A3;Speeldagen!$B$2:$B$9;Speeldagen!$C$2:$C$9;X.lookup(A3;Speeldagen!$E$2:$E$9;Speeldagen!$F$2:$F$9;0;0;1);0;1)
SergeiBaklan
Oct 01, 2024Diamond Contributor
Perhaps you may share sample file removing sensitive information?