Expression List Box

[#1]

Hi All

I have a list box which has thousands invoice numbers.  The invoice numbers either start with "ICT" or "INV".

• Invoice numbers starting with "ICT" relates to sales from Trade Counter.
• Invoice numbers starting with "INV" relates to sales from Head Office.

  I want to create a list box where there are only 2 options and below is my formula , however it does not work

=if([Document No] like 'ICT', 'Trade Counter' , 'Head Office') .

Please can you help and where i am going wrong in the formula?

kind regards

Nayan

[MK_QSL · Accepted solution]

=IF(WildMatch([Document No],'ICT*'),'Trade Counter' , 'Head Office')

[#3]

Thank you Manish.  It worked. Much appreciated.

kind regards

Nayan

[anbu1984]

=if([Document No] like 'ICT*', 'Trade Counter' , 'Head Office')

Or

=if(Left([Document No],3) = 'ICT', 'Trade Counter' , 'Head Office')

[MK_QSL]

easiest way is to create a flag in script just below [Document No] as below...

=IF(WildMatch([Document No],'ICT*'),'Trade Counter' , 'Head Office') as Flag

Now use Flag as List Box