Fill in Value if two cell values match

[LordAcoustic]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel 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

Also,

If you look at the document, you'll see that that Column A and Column C don't match up, but they represent the same Document ID number... Column B represent a category that corresponds to the Document ID in Column A - Without writing 250 if statements I would like to see if I can get the Value in Column B (For a corresponding value match between column A and C) imputed into Column D.

So in this attached file... Column D represents the cell whose value I want it to represent...

Thanks in advance for your help on this.

http://www.mediafire.com/file/tnwby1mmzb4/ExcelHelp.xls

 

[CyberTaz]

That is easy enough, but this is where I get lost...

A2 = 7, B2 = 6, C3 = 7 - I need D2 to equal B2

That's where you lost me, too What you provide absolutely no description
of - nor is there a pattern I can discern in your data - is: What is the
basis on which the formula is supposed to determine what goes into Column D
if the content of A & C *don't* match? The Column D entries in your sheet
where A & C of the same row don't match appear to be "hand picked"... and in
the above example, what bearing does the content of row 2 have on what you
want to appear in C*3*?