Vlookup problem

  • Thread starter Thread starter Amnon Wilensky
  • Start date Start date
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
 
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
Click to expand...

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
 
Back
Top