Return value

In one cell I have a value. It that value is in a column I want to return a alue in another cell. How do I do? For examle:

In cell D6 I have a article no, if the same article no is to be found anywhere in column B I want to return the value of cell C6.