If you're looking for an exact match, this isn't true.

That's what that 4th parm is for.

bnbspop wrote:

<<snipped

You may need to resort your data, n100001 will "smaller" than N90486.
Vlookup is dependent on the table array being sorted from least to
most.

Cheers.

--

Dave Peterson