| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
return value from a dropdown list in other cell
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 |
|
#2
|
|||
|
|||
|
Not sure if I understand exactly the problem you're facing but just as a suggestion try and use an = if formula with the lookup as example
=IF([cell with dropdown menu]<"",(VLOOKUP([cell with dropdown menu],table array,col index num,FALSE)),"") It works on my side, so good luck Quote:
|
|
#3
|
|||
|
|||
|
Quote:
Jera |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select From dropdown and return another dropdown menu | Excel Discussion (Misc queries) | |||
| Select an item from dropdown list but return value from adjacent c | Excel Discussion (Misc queries) | |||
| Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null | Excel Discussion (Misc queries) | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
Linear Mode
