look up one value and return a corresponding value using lists
 

I am trying to use vlookup with validation lists. This is for an invoicing
sheet. What I would like to do is have in one cell a drop down list of the
names of the buckets to bill from and the next cell would do a vlookup and
return the Finance bill account number. The drop down list is working fine,
but the vlookup in the next cell is creating a REF#! error. My list is on a
separate worksheet titled Buckets. The list name is the ValidBuckets. Here
is the formula :
=VLOOKUP(G5,ValidBuckets,Buckets!C1:C37,FALSE)

Can someone help?

look up one value and return a corresponding value using lists
 

What's in

Buckets!C1:C37

?


--

Regards,

Peo Sjoblom


"TKGerdie" wrote in message
...
I am trying to use vlookup with validation lists. This is for an
invoicing
sheet. What I would like to do is have in one cell a drop down list of
the
names of the buckets to bill from and the next cell would do a vlookup and
return the Finance bill account number. The drop down list is working
fine,
but the vlookup in the next cell is creating a REF#! error. My list is on
a
separate worksheet titled Buckets. The list name is the ValidBuckets.
Here
is the formula :
=VLOOKUP(G5,ValidBuckets,Buckets!C1:C37,FALSE)

Can someone help?

look up one value and return a corresponding value using lists
 

The accounting numbers that correspond to the bucket names.

"Peo Sjoblom" wrote:

What's in

Buckets!C1:C37

?


--

Regards,

Peo Sjoblom


"TKGerdie" wrote in message
...
I am trying to use vlookup with validation lists. This is for an
invoicing
sheet. What I would like to do is have in one cell a drop down list of
the
names of the buckets to bill from and the next cell would do a vlookup and
return the Finance bill account number. The drop down list is working
fine,
but the vlookup in the next cell is creating a REF#! error. My list is on
a
separate worksheet titled Buckets. The list name is the ValidBuckets.
Here
is the formula :
=VLOOKUP(G5,ValidBuckets,Buckets!C1:C37,FALSE)

Can someone help?

look up one value and return a corresponding value using lists
 

Never mind. Thanks anyway, but I figured it out. My table array didn't
include both of the columns. and I was using the column index number
incorrectly.

"TKGerdie" wrote:

I am trying to use vlookup with validation lists. This is for an invoicing
sheet. What I would like to do is have in one cell a drop down list of the
names of the buckets to bill from and the next cell would do a vlookup and
return the Finance bill account number. The drop down list is working fine,
but the vlookup in the next cell is creating a REF#! error. My list is on a
separate worksheet titled Buckets. The list name is the ValidBuckets. Here
is the formula :
=VLOOKUP(G5,ValidBuckets,Buckets!C1:C37,FALSE)

Can someone help?