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

"Amnon Wilensky" wrote in
:

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




your formula looks ok, all i can think of is your calculations option
after you change B6 from 1 to 2 try hitting the F9 key
if that changes the formula, then you have your sheet calculations set to
"manual"
- click tools
- click options
- click calculations and change it from manual to automatic.

hope that helps

If you are going to copy that formula down, then you will need to use
absolute references for the rows of the table:

=vlookup(B6,A$1:B$3,2,False)

Hope this helps.

Pete

On Mar 1, 12:30*am, "Amnon Wilensky" wrote:
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

Hi,
That solved the problem,
Thanks to all,
Amnon

"pub" wrote in message
...
"Amnon Wilensky" wrote in
:

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




your formula looks ok, all i can think of is your calculations option
after you change B6 from 1 to 2 try hitting the F9 key
if that changes the formula, then you have your sheet calculations set to
"manual"
- click tools
- click options
- click calculations and change it from manual to automatic.

hope that helps