Return value

[MariaQvarma]

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.

[#2]

@MariaQvarma 

=IF(COUNTIF(B:B,D6)>=1,C6,"not found")

Maybe with this formula as shown in the attached file.