For example, I have two columns as follows:
A B C D
11 50 10 35
23 20
35 10
47 40
59 30

I need the Excel to look up the row first where the value of the column B
equals to cell C. And then, at the same row, pick up the value in column A
and input it into cell D.

Thank you very much.