Formula not populating from dropdown box.Works when entered manua

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???????
 
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.
 
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.
 
Back
Top