Hi Owl,

Give the below ago:

=VLOOKUP(A2,'[Lease Exp 25th Sep.xls]Report!$A$1:$T$65536,22,FALSE)

I have changed the table array to reference an actual range rather than the
whole sheet and added FALSE as the Range lookup. Without this, your formula
will find the closest mach to the lookup value.

Also, you will need to make sure that the list you are looking up is sorded A-
Z on the value you are looking for and that both lookup value and the
righthand column of your table array are both the same format (either both
text or both number). If you expand both columns you will typically find
that text is justified to the left and numbers to the right. (if you using a
later version of Excel you will also find that you have a little green
triangle in the top lefthand corner of the cells)

Once you have tried all of that please let me know if it still doens't work.

Thanks,

Simon


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

Hi Owl,

[quoted text clipped - 25 lines]
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