Bring the cell, not the value of the cell

Hi. I have 5 cells with text. For example,

Column A
blue
white
yellow
red
black

I also have a cell that will be one of the 5 colours. For example, B1=blue. I would like a formula that if B1=blue bring me the cell which contains the blue. So if I put the formula in C1, C1 will be A1, not blue.

Hope you understand what I'm trying to do because my native language is not english!
Thanks for any help!

Thank you for your answer! If you mean =ADDRESS(MATCH(B1,$A$1:$A$5,0),1) this returns $A$1. But if I move the cells to A8:A12 and B1 to B8, the formula =ADDRESS(MATCH(B8,$A$8:$A$12,0),1) returns again $A$1.

Try this ...
="A"&MATCH(B1,A:A,0)

Hi again. I attached my file. At R55 I would like to get I54 because I54 is the same with A14.

Hello
If you want to look across row 54 and find the address of the A14 value:

Formula:

Please Login or Register  to view this content.

These are absolute references but they could be made relative.

Hope this helps.
DBY

Thank you DBY! This was what I wanted!

Thank you oeldere and Phuocam for your effort!

Glad we could help. Thank you for the Rep mark.