Find Duplicate Values and Return Another Value

[stacy.mcmillan]

Hello everyone...

I have an issue that I simply cannot figure out. I have a table, with
3 columns of data. Column A contains various values. Column C
contains various values, some of which may or may not be in Column A,
and could be out of order. Column D contains values that are directly
associated with Column C, and must remain in the same order as Column
C.

What I need to do is to take the value in Column A, look at all the
vlues in Column C, and if it finds a match, return the value in Column
D that is associated with the value in Column C... Not the table below
that will hopefully explain better:

A B C D
Cat 1 Dog 1
Dog 2 Cat 2

In the case above... Column A, Cat, should have a '1' next to it and
not an '2'...

Any help would be greatly appreciated on this... Thank You!!

Stacy

 

[vezerid]

Stacy,
your post is confusing me. In your second paragraph you describe
something and then you say NOT this. But what? What is the criterion by
which B1 should contain 1 and not 2?

Kostis Vezerides