I'm trying this function but the only one that works is the very first one.

C31 can be PVHH or PVHI or PVLO and the conditions apply based on C33.

=IF(C31="PVHI",IF(C33="Low","Target_Hi",IF(C31="PVLO",IF(C33="Low","Target_Lo",IF(C31="PVHI",IF(C33="High","Standard_Hi",IF(C31="PVLO",IF(C33="Low","Standard_Lo",IF(C31="PVHI",IF(C33="Urgent","Critical_Hi",IF(C31="PVLO",IF(C33="Urgent","Critical_Lo",IF(C31="PVHH",IF(C33="Urgent","Critical_Hi",IF(C31="PVLL",IF(C33="Urgent","Critical_Lo",IF(C31="OFFNORM",IF(C33="Urgent","Critical",IF(C31="OFFNORM",IF(C33="HIGH","Standard",IF(C31="OFFNORM",IF(C33="LOW","Target",IF(C33="Delete","Delete",IF(C33="NOACTION","NOACTION"))))))))))))
Thank you for the help!