Connecting drop down list selection to data

[hypnogic]

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!!!!

 

[OssieMac]

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.

 

[hypnogic]

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.

 

[hypnogic]

Thanks much! This was the missing piece. Much gratitude your way.