software

=VLOOKUP(B21,{quot;Canonquot;,2;quot;Compaqquot;,3;quot;Dellquot;,4;quot;Eizoquot; ,5;quot;Fujitsuquot;,6;quot;HPquot;,7;
quot;IBMquot;,8;quot;Lexmarkquot;,9;quot;Sonyquot;,10;quot;Toshibaquot;,11;quot;Otherquot; ,12},2,1)

The above VLOOKUP table works fine up to quot;Toshibaquot;,11;
When it uses quot;Otherquot;,12; as the criteria it returns the value as a 9
instead of a 12??
Anybody any ideas?--
grahammal
------------------------------------------------------------------------
grahammal's Profile: www.excelforum.com/member.php...oamp;userid=20336
View this thread: www.excelforum.com/showthread...hreadid=530932Change the quot;1)quot; at the very end to quot;FALSE)quot;

quot;grahammalquot; wrote:

gt;
gt; =VLOOKUP(B21,{quot;Canonquot;,2;quot;Compaqquot;,3;quot;Dellquot;,4;quot;Eizoquot; ,5;quot;Fujitsuquot;,6;quot;HPquot;,7;
gt; quot;IBMquot;,8;quot;Lexmarkquot;,9;quot;Sonyquot;,10;quot;Toshibaquot;,11;quot;Otherquot; ,12},2,1)
gt;
gt; The above VLOOKUP table works fine up to quot;Toshibaquot;,11;
gt; When it uses quot;Otherquot;,12; as the criteria it returns the value as a 9
gt; instead of a 12??
gt; Anybody any ideas?
gt;
gt;
gt; --
gt; grahammal
gt; ------------------------------------------------------------------------
gt; grahammal's Profile: www.excelforum.com/member.php...oamp;userid=20336
gt; View this thread: www.excelforum.com/showthread...hreadid=530932
gt;
gt;


Thanx for the remedy mate that works fine.--
grahammal
------------------------------------------------------------------------
grahammal's Profile: www.excelforum.com/member.php...oamp;userid=20336
View this thread: www.excelforum.com/showthread...hreadid=530932
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.--
ANDYGM
------------------------------------------------------------------------
ANDYGM's Profile: www.excelforum.com/member.php...foamp;userid=3452
View this thread: www.excelforum.com/showthread...hreadid=530932