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

Yes, you need to change $1:$500 to the proper address of your table (for
example, $E$1:$Z$500)

Regards,
Fred.

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

Your lookup table here is defined as all rows from 1 to 500,
presumably using column A as the lookup vector, yet you are using A6
as the lookup item and you want to return data from the 13th column
(M?). Where is your table located? (i.e. which columns?)

Pete

On Nov 13, 1:03*am, 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

$1:$500, what sheet is this? What columns?
--
** John C **

"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

I'm trying VLOOKUP(A6,$1:$500,13,false) but it's not working.

There's nothing wrong with the syntax of the formula so you'll have to tell
us what "it's not working" means. If A6 is a unique entry in column A then
the formula will return the value from M6.

--
Biff
Microsoft Excel MVP


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

Brilliant! many thanks

I'm used to using lookup from another sheet where $1:$500 covers everything.

I appreciate your time.

Rob

"Fred Smith" wrote:

Yes, you need to change $1:$500 to the proper address of your table (for
example, $E$1:$Z$500)

Regards,
Fred.

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

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

Thanks, group! I was trying to use the VLOOKUP functions for the first time.
This thread told me a lot better than the Excel Help did how to do it.
--
Für Elise - Support the Breast Cancer & Heart Foundations


"Shane Devenshire" wrote:

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