Vlookup problem

[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

 

[pub]

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

 

[Pete_UK]

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

 

[Amnon Wilensky]

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