Excel updated sells

when I added a vlookup formula and drag it to more sells the table not updated automatically.

only when i stand on one of the non updated sell and chose the formula from the formula bar and chose ENTER the sell updated.