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
Bookmarks