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