sample.PNG

Hi!
Let me ask for help. I would like to create a function based on IF statement (or possibly other) that returns categories such in red (in attachment) based on multiple conditions like shown below:


e.g.
Function ReturnValue() as String
     IF COUNTRY = "USA" AND CITY = "Denver" AND CLIMATE = "mild" AND JobOpp = "medium" Then
            ReturnValue = "ABC"
     ELSEIF COUNTRY = "France" AND JobOpp = "medium" Then 
            ReturnValue = "GHI"
       ...  etc .....

Categories would be defined by populated cells.
The # of columns and # of categories would be variable.