Using Vlookup with validation

[Guest]

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?

 

[Bob Phillips]

Show the formula and sample data.

--

HTH

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

 

[Guest]

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]

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