B2 contains a number, the FALSE is the 4th argument in the Vlookup. One of
these numbers is repeated in the first column of the table, and the lookup
table isn't sorted.
In the past this hasn't made a difference, if something is repeated it just
returns the first response, and its never made a difference if they're in
order or not.
I deleted the multiple and ordered the lookup table, but I still get the
same error.

"robert111" wrote:


Are you typing in "false" in cell B2? Does the lookup table have only
one "false" in its first column, and is first column in ascending or
descending order?


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=533677