ExcelBanter - vlookup: I have to double click each cell to get correct results?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - vlookup: I have to double click each cell to get correct results? (https://www.excelbanter.com/excel-worksheet-functions/67032-vlookup-i-have-double-click-each-cell-get-correct-results.html)

gillyd

vlookup: I have to double click each cell to get correct results?

Hi - users have been using an existing vlookup which worked well - now when
they copy down the formula it retains the previous cell contents until they
double click and press enter in each cell which then updates with the correct
information?? Can anyone help please?

Niek Otten

vlookup: I have to double click each cell to get correct results?

ToolsOptionCalculation, check Automatic

--
Kind regards,

Niek Otten

"gillyd" wrote in message
...
Hi - users have been using an existing vlookup which worked well - now
when
they copy down the formula it retains the previous cell contents until
they
double click and press enter in each cell which then updates with the
correct
information?? Can anyone help please?

gillyd

vlookup: I have to double click each cell to get correct resul

Many thanks Niek - really appreciate it!!

"Niek Otten" wrote:

ToolsOptionCalculation, check Automatic

--
Kind regards,

Niek Otten

"gillyd" wrote in message
...
Hi - users have been using an existing vlookup which worked well - now
when
they copy down the formula it retains the previous cell contents until
they
double click and press enter in each cell which then updates with the
correct
information?? Can anyone help please?

All times are GMT +1. The time now is 05:14 PM.