auto update or resync values in data validated lists

Formula for I31:

=IF(LEFT(F31,5)="Cable", INDEX(INDIRECT(VLOOKUP(F32, table4d1aconfig, 2, 0)),1),"Not Applicable")

Code adjusted to reapply the I31 formula when you change F31:

Option Explicit

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address = "$F$31" Then
    Range("F32").FormulaR1C1 = "=INDEX(INDIRECT(VLOOKUP(R[-1]C, table4d1a, 2, 0)),1)"
    Range("I31").FormulaR1C1 = "=IF(LEFT(RC6,5)=""Cable"", INDEX(INDIRECT(VLOOKUP(R[1]C6, table4d1aconfig, 2, 0)),1),""Not Applicable"")"
ElseIf Target.Address = "$F$32" Then
    Range("I31").FormulaR1C1 = "=IF(LEFT(RC6,5)=""Cable"", INDEX(INDIRECT(VLOOKUP(R[1]C6, table4d1aconfig, 2, 0)),1),""Not Applicable"")"
End If

End Sub