Match by multiple criteria and closest value

Hi

I'm trying to fill the PRICE to Col G, from the table in Col A-C,
by PART# and closest QUANTITY.
Example:
Row3 - X1 700 PRICE in Col G Should be 2.6 --> ABS(500-700) = 200 | ABS(1000-700) = 300

1111.JPG

I tried to use the INDEX and MATCH functions

{=INDEX($C$2:$C$9,MATCH(MIN(ABS($B$2:$B$9-F2)),ABS($B$2:$B$9-F2),0))}

Tried to take into account the PART# in several ways but couldn't get the right results.

I'll be glad to receive your help.