| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best method to populate cell based upon drop down list selection
I am trying to populate a cell with text based upon a drop down list
selection. I have tried the following but when tested, results are not always correct (a toucan is a bird, but a palmino is not a dog) Also, african grey returns #N/A. =LOOKUP(G16,{"pointer","collie","poodle","palomino ","thoroughbred","quarter","parakeet","african grey","toucan"},{"dog","dog","dog","horse","horse" ,"horse","bird","bird","bird"}) What am I missing? Drop Down List pulls from a source within the worksheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to populate a drop down list based on the selection of ano | Excel Discussion (Misc queries) | |||
| How to Auto-populate cell based on selection of a list item | Excel Discussion (Misc queries) | |||
| auto populate cell based on previous cell drop down list selectio. | Excel Discussion (Misc queries) | |||
| Auto populate several cells based on a selection from drop down li | Excel Discussion (Misc queries) | |||
| need to populate several cells based on drop down menu selection | Excel Discussion (Misc queries) | |||
Threaded Mode
