How to check the columns in google sheet with 2 input dialog values

I have attached a snippet which is one of the use case to be implemented. I’m unable to write a logic to check the conditions in google sheet (where the assessment result is saved) by using 2 inputs from the user (email, topic selected from the dropdown using input dialog). i have written the logic to be used in red color in the snippet. please help me to proceed further.