Silly Question with VLOOKUPS

ekeenan81

New Member
Joined
Dec 8, 2010
Messages
39
I have a large vlookup recing two files together.

When I copy the formula down, it is looking to the right fields, but I have to go into the formula and return/tab out for it to update the figiure

Ex.

=VLOOKUP(E79,'03071808'!$A$1:$BJ$1033,6,FALSE)

But it is grabbing the value I had in the formula from the line above, but if I tab out of the formula it updates as it should, but I really do not want to do this to update 500 rows.

Thanks again, you guys are great.
 

Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,890
Office Version
  1. 365
Platform
  1. Windows
Is your calculation set to manual or automatic?
 

ekeenan81

New Member
Joined
Dec 8, 2010
Messages
39
Maybe it is just a property of Excel 2007, but when I save my spreadsheet the vlookup auto-updates with correct values.
 

JackDanIce

Well-known Member
Joined
Feb 3, 2010
Messages
9,890
Office Version
  1. 365
Platform
  1. Windows
Sounds like your calculation method is set to manual. You need to change it to automatic
 

Forum statistics

Threads
1,144,611
Messages
5,725,302
Members
422,608
Latest member
bswg5882

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