Nov 07 2022 08:48 PM
I am trying to have the formula return the colour of the cell as well as the text contained in the cell in my Index Match Formula.
This is the formula: - =IF(OR($S9="",$R9=""),"",INDEX('Risk Matrix'!$B$5:$F$9,MATCH($R9,'Risk Matrix'!$A$5:$A$9,0),VALUE(LEFT($S9,1))))
Does anyone have any ideas please ?
Nov 08 2022 12:21 AM
Nov 09 2022 07:33 PM