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
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
50,509
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
 

Forum statistics

Threads
1,141,011
Messages
5,703,723
Members
421,311
Latest member
tanujath

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top