How to match a value appearing several times in the rang with multiple combination

Dear All
Please any one help me how to pull out price for part number that matches with one type say "NU" and one class say " " & one part no say 206.
A B C D
type part no class Unit Price
NU 206 4.76
NU 206 E 5.24
NU 206 EK 5.24
NU 206 EM 6.10
NU 206 EMA 6.10
NU 206 ETN 5.24
NUB 206 E 5.97
NUP 206 6.13
NUP 206 E 6.74
NUP 206 M 7.65
NUP 206 EM 7.84
NUP 206 EMA 7.84
NUP 206 ETN 6.74
how to use index and match formula to pull the corresponding value from price column above
E F
NU
BLANK
Part no price
206
207
208
209
The part numbers are in thousands and duplicated many times in the range because they are to be treated differently because of different type and class attached to it. Even the type and part no may be same with different class.
I TRIED THE FORMULA IN F COLUMN AS BELOW
INDEX(D3:D16,MATCH("NU"&E4&" ",A3:A13&B2:B13&C2:C13,0))
This is not working.Please anyone help!

Originally Posted by JBeaucaire

When you create these scenarios, it's simplest to add a "key" column to your dataset that concatenates the values together into a single unique key code for each row. Then an INDEX/MATCH formula can easily find your multivalue matches.

Thanks a tonnnn for showing the correct way to handle my problem, appreciate, Thanks once again