You want to make left VLOOKUP
Try :
=VLOOKUP(B1;CHOOSE({2;1};W100:W105;X100:X105);2;FA LSE)

Formula =CHOOSE({1;2;3;€¦.};col1;col2;col3;€¦) return an array.
So, you can make VLOOKUP between columns where ever they are, even in
different sheets or books.
For example:
vlookup between 2 columns (columns no in same array):
=VLOOKUP(xxxx;CHOOSE({1;2};A1:A100;D1:D100));2;0)

Left vlookup:
=VLOOKUP(xxxx;CHOOSE({2;1};A1:A100;B1:B100));2;0)

vlookup between column and row:
{=VLOOKUP(xxxx;CHOOSE({1;2};A4:A13;TRANSPOSE(A2:J2 ));2;0)}


vlookup between 2 books:
{=VLOOKUP(D1;CHOOSE({1;2};
'C:\examples\[book1.xls]Sheet1'!$A1:$A2000;
'C:\examples\[book2.xls]Sheet1'!$C100:$C2099);2;FALSE)}

Ioannis Varlamis, Athens


"Rui" wrote:

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"