A

#### Amnon Wilensky

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