Lookup vector - result vector

**abousetta** · 08-23-2011, 01:35 AM

Hello,

I have used Lookup before but am getting inconsistent results with this formula and am wondering if anyone can see what is going on:

=LOOKUP(A1,{"Cat","Dog","Horse","Cow","Chicken","Pig","Donkey","Elephant","Monkey"},{1,2,3,4,5,6,7,8,9})

Cat	1
Dog	5
Horse	8
Cow	5
Chicken	5
Pig	9
Donkey	7
Elephant	8
Monkey	9

abousetta

**arthurbr** · 08-23-2011, 02:19 AM

The lookup vector should be sorted alphabetically

**hilbily** · 08-23-2011, 02:20 AM

Try the following correction to the syntax:
=LOOKUP(A1,{"Cat","Dog","Horse","Cow","Chicken","Pig","Donkey","Elephant","Monkey";1,2,3,4,5,6,7,8,9})

**abousetta** · 08-23-2011, 02:59 AM

Thank you both for the suggestions. Works now.

abousetta

Re: Lookup vector - result vector