View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Thalarctos Thalarctos is offline
external usenet poster
 
Posts: 4
Default 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.