I have a spreadsheet that has duplicates (like CX1) in the A Column with Price in the B column, as below:

Part Price
CX1
CA2 $0.5
CX1
BD5
CX1 $4

Only ONE entry/row of each part, as in Part CX1, has a Price.

I need find the CX1 row that has a Price and Return the Price. Price could be a number or text.

How do I do this? Vlookup and Match find the first entry, which may not be the one.