J
John
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
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