Prev: Send a Sheet as body of Outlook Email
Next: help with filtering
From: willwonka on 19 Mar 2010 12:16
So I have two columns of Data Validations:

Column A we'll call Cost Centers
Column B we'll call Accounts


If somebody puts in a Cost Center for a specific department which we
will call Advertising, then a different list shows up in Column B of
only Advertising Accts. I use the following formula in Column B for
my Data Validation:


=IF(ISERROR(VLOOKUP(A5,advertising,1,0)),accounts,advaccts) where
"accounts" is all accounts and "advaccts" is only advertising
accounts.


That works ok. I'm sure that is not the best way of doing it; but
here is my problem.


If I don't put anything in Column A, users can type anything into
Column B and there is no Data Validation. I was hoping that it would
use the "accounts" list as validation if nothing was entered into
Column A.


Thoughts on how to keep data validation on column B if nothing is put
into Column A?



From: Luke M on 19 Mar 2010 13:08
See your earlier post.

--
Best Regards,

Luke M
"willwonka" <willwonka(a)discussions.microsoft.com> wrote in message
news:629F3A8D-C646-4116-B6D6-ADAA6295F1C3(a)microsoft.com...
> So I have two columns of Data Validations:
>
> Column A we'll call Cost Centers
> Column B we'll call Accounts
>
>
> If somebody puts in a Cost Center for a specific department which we
> will call Advertising, then a different list shows up in Column B of
> only Advertising Accts. I use the following formula in Column B for
> my Data Validation:
>
>
> =IF(ISERROR(VLOOKUP(A5,advertising,1,0)),accounts,advaccts) where
> "accounts" is all accounts and "advaccts" is only advertising
> accounts.
>
>
> That works ok. I'm sure that is not the best way of doing it; but
> here is my problem.
>
>
> If I don't put anything in Column A, users can type anything into
> Column B and there is no Data Validation. I was hoping that it would
> use the "accounts" list as validation if nothing was entered into
> Column A.
>
>
> Thoughts on how to keep data validation on column B if nothing is put
> into Column A?
>
>
>


From: willwonka on 19 Mar 2010 13:10
I do apologize for double post. I did not know that Microsoft site
fed to google groups.

I do now. ;-)


On Mar 19, 12:08 pm, "Luke M" <lukemor...(a)nospam.com> wrote:
> See your earlier post.
>
> --
> Best Regards,
>
> Luke M"willwonka" <willwo...(a)discussions.microsoft.com> wrote in message
>
> news:629F3A8D-C646-4116-B6D6-ADAA6295F1C3(a)microsoft.com...
>
>
>
> > So I have two columns of Data Validations:
>
> > Column A we'll call Cost Centers
> > Column B we'll  call Accounts
>
> > If somebody puts in a Cost Center for a specific department which we
> > will call Advertising, then a different list shows up in Column B of
> > only Advertising Accts.  I use the following formula in Column B for
> > my Data Validation:
>
> > =IF(ISERROR(VLOOKUP(A5,advertising,1,0)),accounts,advaccts) where
> > "accounts" is all accounts and "advaccts" is only advertising
> > accounts.
>
> > That works ok.  I'm sure that is not the best way of doing it; but
> > here is my problem.
>
> > If I don't put anything in Column A, users can type anything into
> > Column B and there is no Data Validation.  I was hoping that it would
> > use the "accounts" list as validation if nothing was entered into
> > Column A.
>
> > Thoughts on how to keep data validation on column B if nothing is put
> > into Column A?- Hide quoted text -
>
> - Show quoted text -

 | 
Pages: 1
Prev: Send a Sheet as body of Outlook Email
Next: help with filtering