IF or VLookup or BOTH ??

Hi !


I'm really stuck on this one...

I have to create a table from which I need to extract conditional data on another sheet....


On the example included the purpose is :

On the data sheet the prices are ordered by size 0.50-0.75-1-1.25...etc
and by clarity coll-Sp1-Sp2....etc...

Now I'm trying to find out how to automatically retrieve those prices on the worksheet..after I fill in the weight and the clarity

So for example if I fill in 0.75 on the worksheet(C2) and then i select Sp1(B4) , I'd like to have the price appear automatically in C4...

Then Sp2(B5) -> 85(C5)
Sp3(B6) -> 50(C6)

ETC........


Thanks to those willing to spare a second of their precious time...
Very much appreciated

Matt That worked great !!!

Only when I tried to apply it to the original it didn't lol


If u'd be so kind to have a look...I don't understand what I'm doing wrong

Thank You