Multiple IF statements in VBA

Hey All,

I am attempting to put multiple IF statements into a cell via VBA
Reason for VBA: Cleanliness for my users, I dont want them messing around with Formulas etc plus the sheet that the formula is being entered into is massivly modified before this formula is put in via VBA - It is copied from another sheet, multiple rows deleted, multiple formats etc.

I am attempting to set the following IF statements

If any cell in Column E is equal to;
How do I
I need a Change
I need Help
I need help with Source IT
Then enter the text "V" into the cell on the same row in Column G

If Column E is equal to;
OTHER
Then put the text "O" into the cell on the same row in Column G

If anything else leave blank.

Please see attached outcome sheet.

Any help is greatly appreciated!