match and index to return same value for multiple occurances.

[omairhe]

Hey excel gurus,

I would like my match and index formula to output me values that are reoccurring in my column A and not just for the first instance.

for example my data looks like this

[TABLE="class: grid, width: 400, align: center"]
<tbody>[TR]
[TD]column A[/TD]
[TD]column B[/TD]
[TD]column C[/TD]
[TD]column D[/TD]
[/TR]
[TR]
[TD]apple
[/TD]
[TD][/TD]
[TD]apple[/TD]
[TD]sweet[/TD]
[/TR]
[TR]
[TD]banana
[/TD]
[TD][/TD]
[TD]banana[/TD]
[TD]yellow[/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

formula to output values in column B

[TABLE="class: grid, width: 400, align: center"]
<tbody>[TR]
[/TR]
[TR]
[TD]column A[/TD]
[TD]column B[/TD]
[TD]column C[/TD]
[TD]column D[/TD]
[/TR]
[TR]
[TD]apple
[/TD]
[TD]sweet
[/TD]
[TD]apple[/TD]
[TD]sweet[/TD]
[/TR]
[TR]
[TD]banana
[/TD]
[TD]yellow[/TD]
[TD]banana[/TD]
[TD]yellow[/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD]sweet[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]apple[/TD]
[TD]sweet[/TD]
[TD][/TD]
[/TR]
[TR]
[/TR]
</tbody>[/TABLE]


Anyone? Will appreciate a lot.

 

[Fluff]

How about
=VLOOKUP(A2,$C$1:$D$2,2,0)

 

[omairhe]

How about
=VLOOKUP(A2,$C$1:$D$2,2,0)

Thank you for your help.

 

[Fluff]

You're welcome & thanks for the feedback