I've been looking at Debra Dalgleish's examples but still not sure how this
can be done.

If cell C6="no" and C10 begins with "International" then use the values in
Column W, if C6=Yes" and C10 begins with "International" then use the values
in Column X. There are a couple more variables but if I can get help this
far, I think I can get the rest.

Thanks for your help!!!
--
maryj

Sounds like

=if(AND(C6="no",left(c10,13)="International"),W1,X 1)



"maryj" wrote:

I've been looking at Debra Dalgleish's examples but still not sure how this
can be done.

If cell C6="no" and C10 begins with "International" then use the values in
Column W, if C6=Yes" and C10 begins with "International" then use the values
in Column X. There are a couple more variables but if I can get help this
far, I think I can get the rest.

Thanks for your help!!!
--
maryj

Just realized that you may have something other than yes/no and Internatonal
in your cells, so here's an update:

=if(AND(C6="no",left(c10,13)="International"),W1,i f(AND(C6="yes",left(c10,13)="International"),X1,"" )

That'll leave a blank in your formula cell if neither situation applies...

"Sean Timmons" wrote:

Sounds like

=if(AND(C6="no",left(c10,13)="International"),W1,X 1)



"maryj" wrote:

I've been looking at Debra Dalgleish's examples but still not sure how this
can be done.

If cell C6="no" and C10 begins with "International" then use the values in
Column W, if C6=Yes" and C10 begins with "International" then use the values
in Column X. There are a couple more variables but if I can get help this
far, I think I can get the rest.

Thanks for your help!!!
--
maryj

I think Mary wants a list. If so, in the DV, select List as the type, and
use a formula of

=IF(AND(C6="no",LEFT(C10,13)="International"),W1:W 10,X1:X10)


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Sean Timmons" wrote in message
...
Sounds like

=if(AND(C6="no",left(c10,13)="International"),W1,X 1)



"maryj" wrote:

I've been looking at Debra Dalgleish's examples but still not sure how
this
can be done.

If cell C6="no" and C10 begins with "International" then use the values
in
Column W, if C6=Yes" and C10 begins with "International" then use the
values
in Column X. There are a couple more variables but if I can get help this
far, I think I can get the rest.

Thanks for your help!!!
--
maryj

Thanks both - you got me on the right track. Here is my formula entered in
the data validation box:
=IF(AND($C$6="yes",ISNUMBER(SEARCH("International" ,$C$10))),RANGE,IF(AND($C$6="no",ISNUMBER(SEARCH(" International",$C$10))),RANGE,IF(AND($C$6="no",ISN UMBER(SEARCH("Domestic",$C$10))),RANGE,RANGE)))
replacing the word "Range" with the actual named ranges..
--
maryj


"Bob Phillips" wrote:

I think Mary wants a list. If so, in the DV, select List as the type, and
use a formula of

=IF(AND(C6="no",LEFT(C10,13)="International"),W1:W 10,X1:X10)


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Sean Timmons" wrote in message
...
Sounds like

=if(AND(C6="no",left(c10,13)="International"),W1,X 1)



"maryj" wrote:

I've been looking at Debra Dalgleish's examples but still not sure how
this
can be done.

If cell C6="no" and C10 begins with "International" then use the values
in
Column W, if C6=Yes" and C10 begins with "International" then use the
values
in Column X. There are a couple more variables but if I can get help this
far, I think I can get the rest.

Thanks for your help!!!
--
maryj