I'm working on a UDF that looks at several cell values...

if value starts with "B" in cell in column B then set variable "map"
to variable "default" if
"SHORT", "SHT" is in the cell in column G
or "G345" or "G231" is exactly in column B.

else set variable "msp" to variable 1