A
Amnon Wilensky
Hi,
I have a problem with the Vlookup formula. It`s only works right on the
first time when I entered the formula but the results don`t change when I am
changing the number on the "Look up value" cell ("B6" for this example).
Here is a simple one:
Column A1:A3=1,2,3
Column B1:B3=a,b,c
Now when I entered the formula and in the "Look up value" cell is the
number "1" (for A1 cell), I get an "a" result (for B1 cell), but if I`ll
change the number in the "look up cell" to "2" (in cell A2), nothing
happened. I have to reenter the formula to get the correct answer which is
"b" (in cell B2).
The formula is: =vlookup(B6,A1:B3,2,False).
Using Excel 2003.
Any help?
Thanks,
Amnon
I have a problem with the Vlookup formula. It`s only works right on the
first time when I entered the formula but the results don`t change when I am
changing the number on the "Look up value" cell ("B6" for this example).
Here is a simple one:
Column A1:A3=1,2,3
Column B1:B3=a,b,c
Now when I entered the formula and in the "Look up value" cell is the
number "1" (for A1 cell), I get an "a" result (for B1 cell), but if I`ll
change the number in the "look up cell" to "2" (in cell A2), nothing
happened. I have to reenter the formula to get the correct answer which is
"b" (in cell B2).
The formula is: =vlookup(B6,A1:B3,2,False).
Using Excel 2003.
Any help?
Thanks,
Amnon