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

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

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


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=493051