vlookup not updating

[DavidGibson]

Hi

On one sheet, I have a vlookup that looks for a value on another sheet and then should find that value on a third sheet and return the second column. At first it looked like it wasn't working, but actually, if I edit the formula (f2) and then just enter, it updates correctly. So it works but doesn't update.

Any ideas on how to solve this.

Thank you
David

 

[Peter_SSs]

David

First, have a look in Tools|Options|Calculation and ensure 'Automatic' is selected.

 

[DavidGibson]

Setting

Hi Peter

I should have said that I have checked automoatic updates and it is set to update automatically. Also, just pressing F9 to update on the formula cell does not update it.

Thanks David

 

[raman_1234]

Re: Setting

Thanks David. This helped me in resolving the issue.

Hi Peter

I should have said that I have checked automoatic updates and it is set to update automatically. Also, just pressing F9 to update on the formula cell does not update it.

Thanks David