Multiple Duplicates and Pick up Key Work Formula

[Huizar]

Hello All,

Need some assistance. I have a spreadsheet with duplicate numbers (3 rows). Each row for that duplicate # has a phrase such in Column Code as Hardware, Removed, Resolved. If I have duplicates how do create a formula to pick up the word "Resolved" for the duplicates?

Thanks in Advance.

 

[Aladin Akyurek]

Care to post a 10 row sample?

 

[Roderick_E]

Not sure if I'm understanding correctly but how about:

=match(target#&code, numbercol&codecol,0) press control+shift+enter to confirm it.
This should return the row number that corresponds with the target# AND the code