Try using FALSE in the range_lookup argument of VLOOKUP (see help for
details). That way the order in the lookup column doesn't matter.

In article ,
samonly wrote:

I can't use any of the lookup or index type functions because the
numbers are not in numerical order. (I tried pasting the lot
(transposed) into a new worksheet and it only works for some values and
not others).