Vlookup

[grahammal]

=VLOOKUP(B21,{"Canon",2;"Compaq",3;"Dell",4;"Eizo",5;"Fujitsu",6;"HP",7;
"IBM",8;"Lexmark",9;"Sony",10;"Toshiba",11;"Other",12},2,1)

The above VLOOKUP table works fine up to "Toshiba",11;
When it uses "Other",12; as the criteria it returns the value as a 9 instead of a 12??
Anybody any ideas?

[Barb Reinhardt]

Change the "1)" at the very end to "FALSE)"

"grahammal" wrote:

>
> =VLOOKUP(B21,{"Canon",2;"Compaq",3;"Dell",4;"Eizo",5;"Fujitsu",6;"HP",7;
> "IBM",8;"Lexmark",9;"Sony",10;"Toshiba",11;"Other",12},2,1)
>
> The above VLOOKUP table works fine up to "Toshiba",11;
> When it uses "Other",12; as the criteria it returns the value as a 9
> instead of a 12??
> Anybody any ideas?
>
>
> --
> grahammal
> ------------------------------------------------------------------------
> grahammal's Profile: http://www.excelforum.com/member.php...o&userid=20336
> View this thread: http://www.excelforum.com/showthread...hreadid=530932
>
>

[grahammal]

Thanx for the remedy mate that works fine.

[ANDYGM]

Reason for problem is that 'Other' is not in alphabetical order, I you moved it to before 'Sony' in the list, it should work properly without the FALSE.