I believe that when you use FALSE or 0 as the fourth argument,the
lookup_value column does NOT ned to be sorted, and if an exact match is not
found it returns #N/A.

HTH
REgards,
Howard

"owl37" wrote in message
...
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.