look up one value and return a corresponding value using lists

T

TKGerdie

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

TKGerdie

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

Similar Threads

Drop down list control value in vba 2
Look up one value and return multiple corresponding values 2
Adding a VLookup to an AutoComplete ComboBox 0
How can I assign a value to a cell without putting a formula in it 4
VLOOKUP returning formula 3
Vlookup and return sheet name also 2
trouble with (complicated) vlookup searching another workbook 2
using strings in vlookup function calls 5

Top