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