lookup value in table

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

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.
 
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
 
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.
 
Brilliant! many thanks

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

I appreciate your time.

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
 
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.
 
Back
Top