The lookup values need to be in the first column of the array, not the last.

HTH

Steve H


"Rui" wrote in message
...
Hi,
i want to do a vlookup, being my lookup value from a validation list.
The answer is #N/A!
Is there a resrtition to the use of this formula with validation date?

heres the example in A1:

=vlookup(b1;example;1;false), where b1 is a validated by the list
"x100:x105" and "example=w100:x105"