need a formula to work out how much ......
 

i got a drop down list in cell e5

the products a
cars
toys
houses
farms
tv
radio
cable
computers
camera
machines
beds
doors


what formula do i write in cell f5 to work out how much of each product i am
selling?
--
please can you help... its urgent

need a formula to work out how much ......
 

From the very little information you gave you would need to have
VLookup formula looking at a list of things but you did not describ
such a list or say where it is located!

Without much more information i'm afraid you probably won't get
response!

regards,
Simo

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=55253