L

#### Legacy 313594

##### Guest

I'm fairly new to VBA, but have been working hard to learn & help my company. I need help consolidating my code though, it's long & continually tests IF statements. The below code runs through about 1500 rows trying to match trade breaks to two seperate spreadsheets depending on whether

Code:

`cells(i,"H) = "CORPLD or Cells(i,"H")="MUNI"`

Can anyone help with consolidating my code? Do I have the right idea with the NESTED IF's or is it an overkill?

Code:

```
For i = 2 To N
If Cells(i, "H") = "FIX" Or Cells(i, "H") = "LCV" Then
GoTo Arsenal2:
End If
If Cells(i, "H") = "MUNI" Then
GoTo London:
End If
If Cells(i, "H") = "CORPLD" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Ladder Trades'!C[-20]:C[-12],9,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "CORPLD" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Ladder Trades'!C[-19]:C[-12],8,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "CORPLD" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Ladder Trades'!C[-18]:C[-12],7,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "CORPLD" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Ladder Trades'!C[-17]:C[-12],6,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "CORPLD" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Ladder Trades'!C[-16]:C[-12],5,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "CORPLD" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Ladder Trades'!C[-15]:C[-12],4,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "CORPLD" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Ladder Trades'!C[-14]:C[-12],3,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "CORPLD" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Ladder Trades'!C[-13]:C[-12],2,FALSE),""Non-Trade Related"")"
End If
London:
If Cells(i, "H") = "MUNI" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Muni Trades'!C[-20]:C[-12],9,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "MUNI" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Muni Trades'!C[-19]:C[-12],8,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "MUNI" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Muni Trades'!C[-18]:C[-12],7,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "MUNI" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Muni Trades'!C[-17]:C[-12],6,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "MUNI" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Muni Trades'!C[-16]:C[-12],5,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "MUNI" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Muni Trades'!C[-15]:C[-12],4,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "MUNI" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Muni Trades'!C[-14]:C[-12],3,FALSE),""Non-Trade Related"")"
End If
If Cells(i, "H") = "MUNI" And Cells(i, "U") = "Non-Trade Related" Then
Cells(i, "U").Formula = "=IFERROR(VLOOKUP(C[-1],'Muni Trades'!C[-13]:C[-12],2,FALSE),""Non-Trade Related"")"
End If
Arsenal2:
Next i
```