I am not a programer, so I need your expertise on a macro with multiple "if" scenarios : Using Excel 2007, I am trying to do everything with one macro.  Which is a combination of multiple if's.

If E147="ESM7" and C147="Bot", then the value shown in O150, if not, then the value shown in Q150.


But If E147="ESU7", then the value shown in O151, if not, then the value shown in Q151.

So, there are 4 if scenarios, beginning with the main cell is ESM7 or ESU7 ,then depending if the next cell value is either a Bot or SLD.

Thanks for your help.