Fill in Value if two cell values match

Hello All,

I'm having difficulty figuring out a function for what I want to do...

The first two columns in my document coincide with their respective values. Column A (File Number) is coded for Participant Description (Column B) and the values in each row are associated with one another...

However, I have a 3rd column (Article Number) whose values mean the same as the File Number column, but the the rows don't match up.

What I need is a fourth column. In this column I'd like the value from the Participant Description column to be imputed if the Article Number and File Number column are the same.

An example from the attached spread sheet.

A2 = 7, B2 = 6, C2 = 7 - I need D2 to equal B2
That is easy enough, but this is where I get lost...
A2 = 7, B2 = 6, C3 = 7 - I need D2 to equal B2

Thanks in advance for your help on this.

A2 = 7, B2 = 6, C2 = 7 - I need D2 to equal B2
That is easy enough, but this is where I get lost...
A2 = 7, B2 = 6, C3 = 7 - I need D2 to equal B2

can you run that again? Where do you get lost?

how about

=IF(A2=C2,B2,"")

so if the value in column A is the same as the one in column C, the value in column B will be returned. Just not sure what you want to do if the values are not the same ...

Are you looking for :

=VLOOKUP(C2,A:B,2,0)

copied down?