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.

Important The values in array must be placed in ascending order:
....,-2, -1, 0, 1, 2, ..., A-Z, FALSE, TRUE; otherwise, LOOKUP may not give
the correct value. Uppercase and lowercase text are equivalent.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Thalarctos" wrote in message
...
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.

Hi,

They lookup vector has to be sorted

=LOOKUP(A1,{"african
grey","collie","palomino","parakeet","pointer","po odle","quarter","thoroughbread","toucan"},{"Bird", "dog","horse","bird","dog","dog","horse","horse"," bird"})
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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.

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

Thank you - I sorted the list for the drop down, but didn't change the order
in the formula.

"Mike H" wrote:

Hi,

They lookup vector has to be sorted

=LOOKUP(A1,{"african
grey","collie","palomino","parakeet","pointer","po odle","quarter","thoroughbread","toucan"},{"Bird", "dog","horse","bird","dog","dog","horse","horse"," bird"})
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"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.