MS office, Excel, 2007

Question

How to get only uniq value (without conflict) by using primary key in MS Excel 2007?

 

Dear Team,

I have a 3 columns data in MS Excel 2007 in which Codes are promary key.

 

 

In another sheet, I will select codes where projects to be displayed but projects code should not be repeated (match-Index-array may be used), I tried formulae (=INDEX($I$6:$I$152,MATCH($K$10,$B$6:$B$152,0))) but project names are not resulting as per my requirement.

 

 

Please share your idea and hint so that i can implement. (Excel sheet copy is attached)