Prev: How do you turn on "view side by side"?
Next: Puzzled about javascript interfering with functions and formatting
From: Thalarctos on 5 Mar 2010 17:07
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","poodle","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.
 | 
Pages: 1
Prev: How do you turn on "view side by side"?
Next: Puzzled about javascript interfering with functions and formatting