Hi,

Am Mon, 5 Nov 2012 19:26:26 +0000 schrieb CH Coffieid:

I am using a vlookup to find a specific value in a 2 column array.
=VLOOKUP(E32,[B4]Resources!$A$2:$B$38,2,1). The problem is it returns
the correct value sometimes and incorrect values at other times. Any
suggestions?

if you use false into the formula the columns must be sorted ascending


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2