Using Vlookup with validation

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?

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

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

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

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

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