How do I use Index match to Return values from One Column based on Comparison between 2 Columns when there are dupes

[excel25newuser]

HI All,

I have the following scenario

I am using the following formula

=INDEX($A$1:$B$12,MATCH(C1,$B$1:$B$12,0),1)

to perform something like
Name 5 in Column C, should print oimnlu in Column D, based on Name 5 value in Column B.

This works fine as long as there are no dupes in Column B and Column C

When we have dupes, for example Column B and C has Name8 as dupe
In this case I would like qqweq and jkhjkh to be printed in Column D for each Name8 in column C, but currently it prints qqweq for both the name8.

How do I achieve what I am after please?

Many thanks

 

[excel25newuser]

Sorry No Idea why my image is not displayed, so trying again

 

[excel25newuser]