Am using match() sort to arrange data but not working

[#1]

Am using expression in the sort tab to sort my items in dimension but not working. what do I do?

[#2]

My sort script:

=match([item text]),
'Cupboards',
'Chairs','Building',
'PEE','Buriet',
,'Isle','JV'
,'Plastics',
'Desktop',
'System unit',
'Prints')

[#3]

my sort script:

=match([item text]),
'Cupboards',
'Chairs','Building',
'PEE','Buriet',
,'Isle','JV'
,'Plastics',
'Desktop',
'System unit',
'Prints')

[sunny_talwar · Accepted solution]

You have a parenthesis at the wrong spot, try this:

=Match([item text], 'Cupboards', 'Chairs', 'Building', 'PEE', 'Buriet', 'Isle', 'JV', 'Plastics', 'Desktop', 'System unit', 'Prints')

[settu_periasamy]

Remove the close bracket after item text..

Should be =match ([item text],.....)

[#6]

Corrected. Didn't work, I had to try it had way because it wasn't working

[#7]

I did that because the default wasn't working

[sunny_talwar]

Do you have the correct case for the values you have provided? Cupboards is different from CUPBOARDS is different from cupboards.

May use Lower() or Upper() or Capitalize() to normalize the data:

=Match(Capitalize([item text]), 'Cupboards', 'Chairs', 'Building', 'Pee', 'Buriet', 'Isle', 'Jv', 'Plastics', 'Desktop', 'System Unit', 'Prints')

[settu_periasamy]

Just wonder, do you have these match values in your dimension ?

and did you uncheck the other sort options for all other dimensions?

[#10]

Yes I used

IF(Match([item text],

'Cupboards',

'Chairs','Building',

'PEE','Buriet',

,'Isle','JV'

,'Plastics',

'Desktop',

'System unit',

'Prints'), [item text]    to pick specific items at my dimension

[settu_periasamy]

Looks close bracket missing in the end.. is that typo?

If yes..no idea..sorry..