The lookup values need to be in the first column of the array, not the last.
HTH
Steve H
"Rui" <[email protected]> wrote in message
news:[email protected]...
> 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"
Bookmarks