Many thanks for that.

I found that all of my user names had a space after them.....

"FALSE" sorted it.

Cheers
LH

Richard Buttrey wrote:
Probably because your data isn't sorted on the column which contains
the a,b,c etc. Check the help to understand the way Vlookup works. It
finds the next highest value and drops back one row. I suspect your
data has a "c" higher up in the list than a "b" and the row before the
"c" row is an "a" row. Hence the formula finds the row higher than
your test value b, and drops back one row,

If you want to run a lookup on an unsorted database, you need to
include the "False" bit in the formula. i.e.

=VLOOKUP(A1,data,2,FALSE)

I generally find that the for most real world examples of Vlookup, the
False bit is vital and should perhaps be the default.


Rgds


On Thu, 13 Oct 2005 10:29:34 GMT, 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


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________