ok so my problem is that i currently have two rows of images, one for home kits and one for away kit images for a football database i entered.
this being my current formula to pull the image dependent on the match that is requested by the user.
=IF(Calculation!$D$31<>"-",INDEX(Kits!$A$2:$B$55,MATCH(Calculation!$B$31,Kits!$A$2:$A$55,0),2),Kits!$D$2)
the formula works for both home and away images, but what im wondering is, is there a way to create a formula that defines the kit selected based upon the colours.
eg at the moment if newcastle is selected black comes up for home and red for away, could i include another area in the formula to allow for the home kit to be displayed in the away column as long as the colour black does not clash with the home team colours. ?
i thought about creating another column for colours, buit how would i add the if statement to the current formula?
this being my current formula to pull the image dependent on the match that is requested by the user.
=IF(Calculation!$D$31<>"-",INDEX(Kits!$A$2:$B$55,MATCH(Calculation!$B$31,Kits!$A$2:$A$55,0),2),Kits!$D$2)
the formula works for both home and away images, but what im wondering is, is there a way to create a formula that defines the kit selected based upon the colours.
eg at the moment if newcastle is selected black comes up for home and red for away, could i include another area in the formula to allow for the home kit to be displayed in the away column as long as the colour black does not clash with the home team colours. ?
i thought about creating another column for colours, buit how would i add the if statement to the current formula?