vlookup query after using fill
 

I used vlookup to find and display a particular cell. This worked fine. I
then use the fill functionality to copy this formula to the columns below.
This seems to work ok with the correct formula being shown in each column but
the result in each of the columns below was the same as the first cell in the
column. When i went into each of the cells below and pressed enter the
correct results then appeared - do i need to do some kind of refresh to sort
this problem out ?

Thanks

vlookup query after using fill
 

Try changing settings in

Tools(MENU)- Options(SUB-MENU)- Calculation(TAB)- Automatic (Radio
Button).

Please rate me.




"davemel" wrote:

I used vlookup to find and display a particular cell. This worked fine. I
then use the fill functionality to copy this formula to the columns below.
This seems to work ok with the correct formula being shown in each column but
the result in each of the columns below was the same as the first cell in the
column. When i went into each of the cells below and pressed enter the
correct results then appeared - do i need to do some kind of refresh to sort
this problem out ?

Thanks