return value from a dropdown list in other cell

Jera Anderson Jera Anderson is offline

Junior Member

Posts: 1

Quote:

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

Hi. Have you found a solution yet? If not, let me know. I've resolved this for you by working on a very similar project.
Jera

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
select From dropdown and return another dropdown menu	RE4379	Excel Discussion (Misc queries)	2	March 11th 10 03:09 PM
Select an item from dropdown list but return value from adjacent c	StevanT	Excel Discussion (Misc queries)	4	March 17th 07 12:39 PM
Compare Value in Cell 1 to a List, Return Value if Match otherwise Return Null	Ben	Excel Discussion (Misc queries)	2	March 15th 07 01:02 AM
result of selecting from the dropdown list should be a dropdown list	No News	Excel Worksheet Functions	0	July 5th 06 04:09 PM
result of selecting from the dropdown list should be a dropdown list	No News	Excel Worksheet Functions	2	July 1st 06 10:53 AM

All times are GMT +1. The time now is 04:23 PM.

Menu

About Us