Find Duplicate Values and Return Another Value
 

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

Find Duplicate Values and Return Another Value
 

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

wrote:
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

Find Duplicate Values and Return Another Value
 

Slightly confused by your second para but if you reall want to look in Col A
find a match in Col c and return Col D try

=VLOOKUP(A1,C:D,2,FALSE)

put in E1 and drag down

" wrote:

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