If, Contains, And formula....it's a long one

[jkelleher]

got another quandary: a formula that does this: If A3 contains a specific day of the week, the return for cell A4, A5, A6 would all be different based on the day of the week identified in A3....so, I've gotten this far:
=IF(ISERROR(FIND("Monday",A3,1)),"6th st. Linden to Tilghman"). I need to add into this formula that if Tuesday is in A#, it returns a different street, if Wed is in A3, it returns a different street...and so on. for wed and friday formulas, I have to add in If cell A4 contains "week A" or "week B" to return specific information to previously mentioned cells......easy right

[pecoflyer]

Please post a sample sheet ( no pics pse) showing what you have and the expected results. Thx

[NoSparks]

Congratulations Jkelleher, you've made my DO NOT HELP list

http://www.ozgrid.com/forum/showthread.php?t=192156

[pecoflyer]

@jkelleher Please read forum rules about cross-posting without links- Thx