it is a data validation drop down list -- and each entry has a series of
different row values. I'd like these row values to auto-generate by simple
selection of the drop-down list item.

I've unsuccessfully tried goal seek, choose, if and value functions. I'm
lost!!!! I have the idea but not the wording.

Thanks for your input. :)

"OssieMac" wrote:

You need to supply more information. Is the dropdown list a data validation
list or a drop down combo box? Perhaps an example of the data in the dropdown
list and an example of what you want the answer to be etc.


--
Regards,

OssieMac


"hypnogic" wrote:

I am trying to create a formula that will automatically insert data when
item(s) are selected from drop down list. Drop down list is text based,
while data is numerical. Help please!!!!