look up one value and return a corresponding value using lists


G

Guest

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?
 
Ad

Advertisements

Ad

Advertisements

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top