Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
Could someone kindly help me write match statement, because my attempt below is not working
If
(Match(CCG_TREND, '2M','3R', '1K', '1J', '9M', '1V'), 'Hampshire') ,If(Match(CCG_TREND, '10X'), 'Southampton') as TestI also want to incoporate another option which will be "Other"
Can anyone kindly help me write this
Thanks
Helen
Try this
if(Match(CCG_TREND, '2M','3R', '1K', '1J', '9M', '1V') > 0, 'Hampshire',
if(Match(CCG_TREND, '10x') > 0,'Southampton',
'Other'))
You dont need the second Match if you are only testing for 1 value, you could just have a simple If so somthing like this
if(Match(CCG_TREND, '2M','3R', '1K', '1J', '9M', '1V') > 0, 'Hampshire',
if(CCG_TREND = '10x', 'Southampton','Other'))