Hi,

First, as Biff stated this is technically a legal syntax, but what does it
mean?

VLOOKUP(A6,$1:$500,13,FALSE)

1:500 means all columns for 500 rows or it is the equivalent of A1:IV500.

But, here's the rub, it looks up the info in the first column of the table
which is A. And you lookup value is in A6, there a problem with overlap.
This would not be a problem if you were refering to another sheet in the
workbook. So the VLOOKUP goes across row 6 to column 13 - M and brings back
the data form M6. Probably not the thing you wanted?

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"Rob" wrote:

Hi everyone

I'm trying to populate C&D from values in a table in the same sheet once the
code is entered in A.
I'm trying VLOOKUP(A6,$1:$500,13,false) but it's not working. Is this enough
information to suggest anything?

thanks

Rob