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 EN...