M
mms
All *excellent* answers... thank you very much!!
I am going to go with
=CHOOSE(MATCH(A1,{\"A-325\",\"A-490\",\"A-500\"},0),\"OPTION1\",\"OPTIO
2\",\"OPTION3\"
for now, as this most closely resembles what I want without having t
use a macro or VBA
I am going to go with
=CHOOSE(MATCH(A1,{\"A-325\",\"A-490\",\"A-500\"},0),\"OPTION1\",\"OPTIO
2\",\"OPTION3\"
for now, as this most closely resembles what I want without having t
use a macro or VBA