Formula not populating from dropdown box.Works when entered manua
 

I have setup a dropdown box with a list of 16 entries. All 16 entries show
in the dropdown box, but only one works to populate the correct answer from
the formula. Example: When "T" is selected the formula should show and
answer of 0.25 and it does. BUT when I select any of the other options,
example: "A" it should show an answer of 1 but nothing populates. If I
remove the drop down box and just enter each selection manually, all the
formulas populate correctly. What should I check???????

Formula not populating from dropdown box.Works when entered manua
 

I assume you are using data validation with a list.

The datavalidation selects one of the values.

You now need to use vlookup to get the selected item to lookup the number in
your list.

I'm sorry it is a little vague but without specific details it is a little
difficult to be more concrete.


--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"Grandmother of 2" wrote:

I have setup a dropdown box with a list of 16 entries. All 16 entries show
in the dropdown box, but only one works to populate the correct answer from
the formula. Example: When "T" is selected the formula should show and
answer of 0.25 and it does. BUT when I select any of the other options,
example: "A" it should show an answer of 1 but nothing populates. If I
remove the drop down box and just enter each selection manually, all the
formulas populate correctly. What should I check???????

Formula not populating from dropdown box.Works when entered manua
 

If the formula is a VLookup, perhaps the values in the lookup table
don't exactly match the values in the dropdown list. One list may have
space characters, and the other doesn't.

Grandmother of 2 wrote:
I have setup a dropdown box with a list of 16 entries. All 16 entries show
in the dropdown box, but only one works to populate the correct answer from
the formula. Example: When "T" is selected the formula should show and
answer of 0.25 and it does. BUT when I select any of the other options,
example: "A" it should show an answer of 1 but nothing populates. If I
remove the drop down box and just enter each selection manually, all the
formulas populate correctly. What should I check???????


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html