With your posted data in A1:C3
and
D1: (the text to find....eg Red)

This formula returns the address of the cell containing that value: 
E1: =ADDRESS(MAX(INDEX((A1:C3=D1)*ROW(A1:A3),0)),MAX(INDEX((A1:C3=D1)*
COLUMN(A1:C1),0)),4)


or...this shorter version..which must be committed with CTRL+SHIFT+ENTER,
(instead of just ENTER)
E1: =ADDRESS(MAX((A1:C3=D1)*ROW(A1:A3)),MAX((A1:C3=D1)*COLUMN(A1:C1)),4)

In the above example, the formulas return: B2

Is that something you can work with?