I'm trying to use the Vlookup function so that when a particular selection is
chosen from a dropdown box, it will then alter data elsewhere in a
spreadsheet.
I only have 4 items to choose from in my dropdown box.....but the formula is
not correctly pulling the Vlookup data I want...
For example....item one in the dropdown box is a bank name.....and then I
use the vlookup formula to populate a bank account number....but when I
choose item two in the dropdown box, my vlookup formula is still pulling the
account number for bank one and not bank two. Any ideas why?

Show the formula and sample data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian" wrote in message
...
I'm trying to use the Vlookup function so that when a particular selection
is
chosen from a dropdown box, it will then alter data elsewhere in a
spreadsheet.
I only have 4 items to choose from in my dropdown box.....but the formula
is
not correctly pulling the Vlookup data I want...
For example....item one in the dropdown box is a bank name.....and then I
use the vlookup formula to populate a bank account number....but when I
choose item two in the dropdown box, my vlookup formula is still pulling
the
account number for bank one and not bank two. Any ideas why?

In cell T2 is the bank name...U2 is bank ABA...V2 is bank account (different
banks/ account in rows 3, 4 and 5)
In cell C12 I have a validation list ($T$2:$T$5) which has four bank
names...these four banks are correctly appearing in my dropdown box....
In cell C21 I have the formula =vlookup(c12,T2:V5,2) where I want the bank
ABA to appear
In cell C22 I have the formula =vlookup(c12,t2:v5,3) where I want the bank
account to populate.
When I select the first bank name from the drop down list, all the data
correctly populates, but when I select the second bank name, the vlookup data
still shows the info that relates to the first in the dropdown list.

"Bob Phillips" wrote:

Show the formula and sample data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian" wrote in message
...
I'm trying to use the Vlookup function so that when a particular selection
is
chosen from a dropdown box, it will then alter data elsewhere in a
spreadsheet.
I only have 4 items to choose from in my dropdown box.....but the formula
is
not correctly pulling the Vlookup data I want...
For example....item one in the dropdown box is a bank name.....and then I
use the vlookup formula to populate a bank account number....but when I
choose item two in the dropdown box, my vlookup formula is still pulling
the
account number for bank one and not bank two. Any ideas why?

Try adding ,False to the tail of your VLOOKUP formulae (before the closing
bracket)

--
HTH

Bob Phillips

"Brian" wrote in message
...
In cell T2 is the bank name...U2 is bank ABA...V2 is bank account
(different
banks/ account in rows 3, 4 and 5)
In cell C12 I have a validation list ($T$2:$T$5) which has four bank
names...these four banks are correctly appearing in my dropdown box....
In cell C21 I have the formula =vlookup(c12,T2:V5,2) where I want the bank
ABA to appear
In cell C22 I have the formula =vlookup(c12,t2:v5,3) where I want the bank
account to populate.
When I select the first bank name from the drop down list, all the data
correctly populates, but when I select the second bank name, the vlookup
data
still shows the info that relates to the first in the dropdown list.

"Bob Phillips" wrote:

Show the formula and sample data.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Brian" wrote in message
...
I'm trying to use the Vlookup function so that when a particular
selection
is
chosen from a dropdown box, it will then alter data elsewhere in a
spreadsheet.
I only have 4 items to choose from in my dropdown box.....but the
formula
is
not correctly pulling the Vlookup data I want...
For example....item one in the dropdown box is a bank name.....and
then I
use the vlookup formula to populate a bank account number....but when
I
choose item two in the dropdown box, my vlookup formula is still
pulling
the
account number for bank one and not bank two. Any ideas why?

It sounds like you may not have set up your Vlookup formula correctly to reference the dropdown box. Here are the steps you can follow to set up Vlookup with validation:

1. Set up your dropdown box with the four items you want to choose from.
2. In the cell where you want the Vlookup result to appear, type in the Vlookup formula. For example, if you want the bank account number to appear in cell B2, your formula might look like this:
   Formula:

   =VLOOKUP(A2,Table1,2,FALSE) 

3. In the formula, A2 should be the cell reference for your dropdown box. Table1 should be the range of cells where your bank names and account numbers are stored. 2 should be the column number where your account numbers are located (assuming bank names are in column 1). FALSE should be included to ensure an exact match is found.
4. Once you have entered the formula, press Enter to see the result.
5. Test the formula by selecting each item in the dropdown box and verifying that the correct account number is displayed.

If you are still having trouble, double-check that your dropdown box and Vlookup formula are referencing the correct cells and ranges. It's also possible that there may be an error in your data that is causing the formula to pull the wrong information.