Index and Match and Duplicate Values.

[omairhe]

Hello all,

I have an Index and Match Formula that looks like the following:-

=INDEX(Sheet2!A:A,MATCH(Sheet1!A1,Sheet2!B:B,0))

Data in Sheet 2 is :-
Col A......Col B

hello	hello
dear	dear
my	my
what	what
is	is
going	going
on	on

<tbody>
</tbody>

Data in Sheet 1 is :-
Col A......Col B.......Col C

hello	hello	hello
dear	dear	dear
hello	hello
my	my	my
dear	dear
what	what	what
what	what
is	is	is
going	going	going
on	on	on
on	on

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

Column A is raw data. Column B is actual result of applying and dragging all the way down the match and index formula. Column C is my imaginary desired results from match and index formula.

So yes. How can I achieve the values in Column C please..

Thanks, will appreciate.

 

[Marcelo Branco]

Try

C1
=IF(COUNTIF(A$1:A1,A1)=1,INDEX(Sheet2!A:A,MATCH(A1,Sheet2!B:B,0)),"")
copy down

M.