[SOLVED] Search value in one column and write the corresponding value

Hello,

I have one problem, maybe someone can help me.

Column1 Column2 Column3
Red White 1
Pink Yellow 4
Blue Green 10
Black Red 7
White Purple 9

If the first value from column 1 "Red" matches one of the value from column2, then write the corresponding value from column3.
I know that I can do with "if" and "match", but I don't know how to take the exact value of the corresponding column3.

Could somebody give me a hint?

Thanks alot,