VLOOKUP - N/A error

with Vlookup first without changing anything.......

Formula:

=VLOOKUP(I2,IF(I2="YES",CHOOSE({1,2},I2,F2*0.5),CHOOSE({1,2},I2,F2)),2,0)

Originally Posted by humdingaling

with Vlookup first without changing anything.......
CHOOSE

I tried to do it just with the included ifs instead, but it didn't work. Is there a way to use the regular formulas along the vlookup? "choose" seems unfamiliar to me.
Also, what do these braces:

Originally Posted by humdingaling

[FORMULA]=CHOOSE({1,2},I2,F2*0.5)

{} - mean? It seems that in this case the formula "choose" always returns the first value, which is I2.
If you put: "{2,1} in these braces, then it will return the second value, which is F2*0.5

BTW, does anyone know why vlookup stops working if for table array parameter you set two different columns that have a gap? I thought parentheses solve this issue of including columns that are separated by a gap...

Originally Posted by FDibbins

The syntax of 2 formulas you have presented in your workbook is incorrect
=VLOOKUP(Q4,($F$2:$F$10,$I$2:$I$10),2,TRUE)
vlookup cannot use non-contiguous ranges like that.

So is that it? No way to add "non-contiguous ranges" to "table array" parameter?



The screenshot, file is attached.