Below is an example:

A D Y
B A N
C B N
D C Y

I need a formula that looks at Column A and finds the match (to the letterin column A) in column B and then returns the value that is in Column C that corresponds to the same row that the match was found in Column B.

Can someone help with this formula?

Thanks!!