I'm using XP and Office 2000.

I just had a problem with a lookup that I can't get it to do what I
want.

=VLOOKUP(E2,Sheet2!E:E,1,0)

This lookup above compared what is in cell E2 on my main sheet to what
is in column E on the second sheet. It then enters the number in the
cell if it exists anywhere on sheet 2 in column E. If not it just
gives the typical #N/A.

What I was wanting it to do was to return the value in the column J
from the second sheet instead of column E so I was trying the
following:

=VLOOKUP(E2,Sheet2!E:E,Sheet2!J,0)

And variation on that but I can't get it to return the value I want.
Is it possible to get it to see if there's a match from one column on
the second sheet but return the value from the same row but different
column?

I think its probably something else I need to do instead of a VLOOKUP?

Cheers very much for any help

John