Limiting what appears in list boxes

[#1]

I'm having some trouble limiting what appears in a list box and none of the suggestions I have found so far on here have worked. Essentially what I have is data for three different companies which I'm organizing a few different ways. For part of it, I have three separate sheets that detail sales information of each company separately. The list boxes on each page have options for Branch ID for all three companies and I would like to limit this to only showing Branch IDs relative to the company who's sheet it's on. I've been trying the editing the expression or using the conditional option, but neither seem to work.

Thanks in advance!

[m_woolf]

Try an Expression, something like:

=if(Company = 'Company A',BranchID)

[maximiliano_vel · Accepted solution]

Perhaps this could help you

[#4]

I had to add brackets to Branch ID because my data title has a space but it worked perfectly! Thank you!