Forum Discussion
Hills998
Nov 08, 2022Copper Contributor
index and match formula to return the text and colour of the cell
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 ?