Your formula looks fine.........probably the reason you're getting the #N/A
is because Excel is not finding your value in the lookup table........could
be one is TEXT vs the other being NUMBERS..........
From HELP:
Remarks
If VLOOKUP can't find lookup_value, and range_lookup is TRUE, it uses the
largest value that is less than or equal to lookup_value.
If lookup_value is smaller than the smallest value in the first column of
table_array, VLOOKUP returns the #N/A error value.
If VLOOKUP can't find lookup_value, and range_lookup is FALSE, VLOOKUP
returns the #N/A value.
hth
Vaya con Dios,
Chuck, CABGx3
"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"
|