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

column A	column B	column C	column D
apple		apple	sweet
banana		banana	yellow
apple
apple

<tbody>
</tbody>

formula to output values in column B

column A	column B	column C	column D
apple	sweet	apple	sweet
banana	yellow	banana	yellow
apple	sweet
apple	sweet

<tbody>
</tbody>

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