I have a Price List in Sheet1 Like
A B C
1 Product Pack Rate
2 Mango Jam 500 Gm 20.00
3 Mango Jam 250 Gm 18.00
4 Pinapple Jelly 500 Gm 35.00
5 Pinapple Jelly 250 Gm 25.00
Continued...to Last
In Sheet2 I
A2 = Validation List of all Pruduct
B2 = validate formula is =Indirect(a1)
C2 = formula is =vlookup(b2,rate,2,0)

The problem is that every time it shows the rate of first pack (i.e. mango
500gm or 250gm),
if I choose other product in A2 also.

But I want to put rate automatically in C2 according my Product and Pack
selection.

Is there any solution for above.

Thanks in advance.