VLOOKUP driving me crazy

L

LB79

Hi all - I have a VLOOKUP formula that is really bugging me. Instead o
reading accross it seems to be reading down. The formular is

=VLOOKUP(A1,OCU_VCU!W1:X20,1)

I cant see whats wrong with it - ive used VLOOKUP so much in othe
projects - Im either really missing something or excel has gone funny.

Thanks for any comments
 
C

chalky

You aren’t giving a huge amount of detail but from what I can see tw
things could be driving the error.

Firstly, by not including FALSE as the range lookup Excel will find th
nearest match to your lookup reference which mightn’t be what you ar
after and secondly you are offsetting by 1, which doesn’t mean mov
over one column it means take the column you find the reference in. I
you want to look up in column W and return a value from X you are goin
to need to right it with a 2. I.e.:

=VLOOKUP(A1,OCU_VCU!W1:X20,2,FALSE) (FALSE is optional)
 
D

Dave O

Instead of reading accross it seems to be reading down.
The V in VLOOKUP is for "vertical". Have you looked into HLOOKUP? (H
is for "horizontal".) That sounds like a better fit.
 
S

Stephen

LB79 said:
Hi all - I have a VLOOKUP formula that is really bugging me. Instead of
reading accross it seems to be reading down. The formular is

=VLOOKUP(A1,OCU_VCU!W1:X20,1)

I cant see whats wrong with it - ive used VLOOKUP so much in other
projects - Im either really missing something or excel has gone funny.

Thanks for any comments.
Click to expand...

Well, that formula is looking up A1 in column W and also returning the value
from column W. Presumably you want the corresponding value from column X, so
you need to change the last parameter from 1 to 2.
 
Top