Risk Assessment formula conversion from excel to smartsheet
I'm trying to convert an excel formula to use in smartsheet without much success.
The excel formula is:
=IFERROR(MATCH($F4,'Lookup Table'!$B$3:$B$7,0)*MATCH($G4,'Lookup Table'!$B$3:$B$7,0),"")
In short, I need the 'Risk Matrix' column in smartsheet to show the score where the probability and impact rating intersect.
I didn't create the excel file (or formula) and am not a formula expert as is probably obvious from my question.
Can anyone help?