Does Vlookup refresh?

[Psy6]

So i finally figured out the date problem then encountered another prob.

The situation is this
I basically have the formula as vlookup(Cell,array,col) where Cell is a text i continually change to scour info.

The first time i enter the vlookup information, it will retrieve the correct information (in terms of correct row and column), after i change the Cell value, it will not refresh. It just stays stuck on the previous value (row/col combination). Anyway around this?

[VBA Noob]

See if calc is set to manual.

Tools > options > calculation tab > tick automatic

Also if you want an exact match you should include a false statement at the end

e.g
vlookup(Cell,array,col,false)

VBA Noob