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.
Bookmarks