Fill down function

P

pon

After doing some V-lookup, i would like to fill down the formula (eg.
=VLOOKUP(B7,[abc.xls]Sheet1!$B:$D,2,FALSE)) to the cells that follow. I did a
fill down, but the cell only shows result of the original cell. I checked the
function of the cells that come after the original cell, and the function
looks fine (eg. =VLOOKUP(B7,[9965794350.xls]Sheet1!$B:$C,2,FALSE) )

Anyone can help?

Thanks in advance!
 
E

Elkar

Make sure that Calculations are set to "automatic".

TOOLS
OPTIONS
CALCULATION Tab
Check "Automatic"
OK

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help matching combined text cells 1
Formula fill series? 1
Need help to fix vlookup function in macro 1
Circular Calculation with TREND Function? 7
Use vlookup within offset? 4
Update cell value based on name and specific date 0
VLOOKUP & Data Validation 0
use of ADDRESS function within CELL function 4

Top