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 at a matchday (fe 1)
(table 1 => looking to fill cell N/B marked in yellow)
The data comes out of sheet 2 but If the team is found in column “Thuisploeg” then the percentage out of column 3 DEF % Thuis should be returned. IF the team is found in column “Uitploeg” then the percentage out of column 4 Def % UIT should be returned.
Any experts that can help me?
Kind regards,
Jan
Hello,I’m doing a search to find the % that belongs to a team ( fe Anderlecht) coupled at a matchday (fe 1)(table 1 => looking to fill cell N/B marked in yellow) The data comes out of sheet 2 but If the team is found in column “Thuisploeg” then the percentage out of column 3 DEF % Thuis should be returned. IF the team is found in column “Uitploeg” then the percentage out of column 4 Def % UIT should be returned. Any experts that can help me?Kind regards,Jan Read More
