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'...