"LB79" wrote in message
...

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.


--
LB79

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.