Multiple IF statements together

[amattey]

Hello,

I am trying to get a formula where if a cell has a x or y, to say "DO ON" &the value on the cell next to the one that contains only the X, otherwise to say "DO NOT DO". Below if what I though the formula would look like but when I type it in gives me an error. Could anyone help?

=IF(B2="x","Do on "&A2),IF(B2="y","Do on "&VLOOKUP("x",A2:E110,4,FALSE),"Do not do")

 

[FKoenig]

So then maybe something like:

=IF(A2>(Sheet2!B2+730),"Do On"&Sheet2!B2,IF(A2<(Sheet2!B2-365),"Do On"&Sheet1!A2,"Do Not Do"))