vlookup not updating

DavidGibson

New Member
Joined
Aug 5, 2006
Messages
5
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
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,797
Office Version
  1. 365
Platform
  1. Windows
David

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

DavidGibson

New Member
Joined
Aug 5, 2006
Messages
5
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

New Member
Joined
Sep 23, 2013
Messages
1
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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,809
Messages
5,544,419
Members
410,610
Latest member
renatha prado
Top