Find Duplicate Values and Return Another Value

  • Thread starter Thread starter stacy.mcmillan
  • Start date Start date
S

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
 
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
 
Back
Top