Help!!!

[OSSIE]

hello here is my dilema i have a list of product that i have on a3 and
want to have a nother list maybe on another sheet with the amount o
this product meaning that i would select the name of the product on a
and on b3 the amount i need of this product and on c3 it would gime th
amount of this selection like if i select on a3 lets say for exampl
rice and on b3 1.5 then on c3 it would give the value of this can thi
be done maybe with a vlookup or index if so can you guys help thank yo
in advanc

 

[Don Guillett]

Can you say that again. This time take a breath.

 

[OSSIE]

sorry for not being more specific
name of product amount total
a2 b2 c2
and if possible have the value of A2 in a different sheet, when
selecting
A2 and the amoun c2 would calculate the amoun according to the value of
A2 if the value of a2 its 1 0r 3 c2 would calculate and so for
thank you in advance