Hi Leigh

It depends whether all of your Lookup column is sorted.
If it is you should get the correct result, or the values in the cell
that has a lower value than the looked up value when the 4th argument to
VLOOKUP isn't used.
=vlookup(a1,data,2,0) with the 4th argument as 0 of FALSE will deal with
unsorted data and looks for an exact match else it returns the #N/A value.

Regards

Roger Govier



leigh wrote:

Just checked this and it works.

I have it running on a bigger table - only 150 lines and I have the
problem.

Any suggestions ??

LH

----


leigh wrote:

All,

When I run vlookup on a selected range of data, then answers returned
to me are from the cell directly above.

ie:-

a 10 1
b 20 2
c 30 3

if the above date was my range ("data") and I use the formula:-
=vlookup(a1,data,2)

I put "b" in cell a1 and it will return me the data for row a,10,1

why would it do that ?!?!?

LH