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


--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=548716

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

--
Don Guillett
SalesAid Software

"OSSIE" wrote in message
...

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


--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile:
http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=548716

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


--
OSSIE
------------------------------------------------------------------------
OSSIE's Profile: http://www.excelforum.com/member.php...o&userid=31638
View this thread: http://www.excelforum.com/showthread...hreadid=548716