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
instead of a 12??
Anybody any ideas

 

[Guest]

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

 

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