Best method to populate cell based upon drop down list selection
You have a couple of solutions, but I would do this:
Create a new sheet (name it AnimalTable
Create a table in columns A:B
Column A is the pointer, collie, poodle, ..
Column B is the type of animal
Then I could use:
=vlookup(g16,animaltable!a:b,2,0)
I find that dedicated tables on dedicated worksheets like this are easier to
update.
Thalarctos wrote:
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.
--
Dave Peterson
|