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?