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

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Is your calculation set to manual or automatic?
 
Upvote 0
Maybe it is just a property of Excel 2007, but when I save my spreadsheet the vlookup auto-updates with correct values.
 
Upvote 0
Sounds like your calculation method is set to manual. You need to change it to automatic
 
Upvote 0

Forum statistics

Threads
1,217,449
Messages
6,136,699
Members
450,025
Latest member
Beginner52

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
Back
Top