VLookUp Formula Will Not Calculate

D

Daniel

I wrote a correct VLookUp function, and it is calculating correctly. When I
drag the function down the column to populate the rest of the neccessary
fields, it populated the "looked up" answer for the first cell instead of for
the appropriate cell. If I click in each cell individually (as if to edit the
text) and then click away, the correct answer appears. How do I make this
happen for all the cells without clicking each one seperatly (there are 1000
rows) ...
 
B

Bondi

Daniel said:
I wrote a correct VLookUp function, and it is calculating correctly. When I
drag the function down the column to populate the rest of the neccessary
fields, it populated the "looked up" answer for the first cell instead of for
the appropriate cell. If I click in each cell individually (as if to edit the
text) and then click away, the correct answer appears. How do I make this
happen for all the cells without clicking each one seperatly (there are 1000
rows) ...
Click to expand...

Hi Daniel,

Maybe you have set the calculations to Manual.

Try and copy down and hit F9

Or you could go to Tools -> Options -> Calculations and under
calculations click the Automatic.

Regards,
Bondi
 
Top