|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
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.