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