VBA- Nested If Statements

[Magnum83C]

Hello,

I am new to VBA and having trouble creating a Nested IF statement with multiple criteria. The formatting of VBA is quite unfamiliar to me, If somebody could start the first lines of code in which I could mimic for a loop it would be much appreciated. Thank you so much.

I would like the code to do something like this; (Please refer to the excel doc)
"Criteria": is what i want incorporated in the IF statements logical test
"Data Set": Is the raw data I see on my end

I would like the output to be in column G. This is how it would be coded in excel without VBA for 2 sets of criteria. The problem is I have a lot of sets of criteria. This is also shown in the excel doc.

=IF(AND(H3="Non Structured",OR(I3="PUB",I3="MNY",I3="PBC",I3="PFB",I3="PFG",I3="PBB",I3="PBL",I3="PHM",I3="PHU",I3="RPO"),AND(K3="Bonds")),"Nope",IF(AND(H3="Structured",OR(I3="PUB",I3="p01",I3="PBC",I3="PHU"),AND(K3="Bonds")),"Yes", IF(AND(.......

Note: "Value if false" is another IF statement testing for a new set of criteria.

Essentially I would loop this formula for the entire column of G, but adjusting it to add other Investment Categories too (Structured, Non Structured). So for every cell in Column G it would look at the data in columns H-K and spit out an output accordingly.

Hopefully this is clear, thank you!