ToolsOptionsCalculation.

Change it to "Automatic".


Gord Dibben MS Excel MVP

On Thu, 12 Oct 2006 07:38:02 -0700, owl37
wrote:

Hi Simon,
I tried removing the $ but this didn't seem to work.
The spreadsheet is as follows:

Property comments
62411003 0
62411009 0
62411010 0
62411011 0
62411014 0
62418001 Working with Joe to Rehouse

The formula in the first cell is as follows:
=VLOOKUP(A2,'[Lease Exp 25th Sep.xls]Report!$1:$65536,22)

So, It is the comments column that I want to fill using the vlookup.
Does this shed any light at all?
For the table array I tried using a range name but this didn't work.
Thanks for your help so far.

Owl37





"smw226 via OfficeKB.com" wrote:

Hi Owl,

If your formula contains and $ then try removeing them.

This should allow your code to work.

However, be very carefull when doing this as if you drag your function in the
wrong direction it will stop working all together. I would suggest just
removing all of the $'s from before the row number if dragging down or before
the column letter if dragging accross. ie$A4 or A$4 as this will keep the
other portion absolute.

HTH

Thanks,

Simon

owl37 wrote:
Hi,
I am using a vlookup to extract comments relating to particular ref. no's
from a seperate worksheet.
The vlookup has been created and works for one cell.
However, when I try to autofill it down it copies the formula OK but the
results don't change.
Whne I double click in each cell and press enter the formula seems to
refresh and starts to work.
There are over 600 instances so this will take some time!
Please help.
Thanks.

--
--------------------
Simon - UK

Email at simon22mports [ a t ] hot mail [ d ot ]com

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200610/1