Originally Posted by martinezfer

Hi, I created a dropdown list and need to return a value in another cell.
When you pick dropdownlist1 option, in other cell put number 4, and so on, depending on the selection
If I use vlookup, for some reason of there is no selection, it returns #N/A. As I need to add the results, this error doesn't let me.
Thanks