Vlookup problem

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
 
P

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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top