O.K I think i have a better way to explain it now. Mangesh your last
formula was vry close to what I need.

The formula needs to be able to distinguish between what is selected in
B1. For instance if food is entered into B1 then the formula must read
from cell B16, but if Beverage is selected in Cell B1 then the formula
needs to know to read the information from cell B17

Can that all be written into 1 formula, so that is knows to refer to
different cells if you have a certain selection from a drop down box
selected ??


--
melben
------------------------------------------------------------------------
melben's Profile: http://www.excelforum.com/member.php...o&userid=23619
View this thread: http://www.excelforum.com/showthread...hreadid=373824