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

--
HTH

Bob Phillips

"Brian" <Brian@discussions.microsoft.com> wrote in message
news:00CE9653-08CD-47DD-B870-DC2EFBFED91B@microsoft.com...
> 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" <Brian@discussions.microsoft.com> wrote in message
> > news:558BAE1D-FB05-427D-A434-08B5D59DD1DC@microsoft.com...
> > > 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?

> >
> >
> >