Search bar not searching by label

[Austin]

I have a drop down that is a reference to codes. When I search in the list, in some locations, it will
search by the label and in other places it is searching by the actual KEY from the referenced table. The places where it is searchable by the key I am using a combined list of references from a table with references to generate a list based on users and their departments.
Below I have listed the valid if formula for the drop down that is searching by key instead of label. I am assuming since it’s not a direct reference to that table it is the cause of the issue.
Would using an IN formula to pull my reference straight from the code table instead of splitting out the keys be a solution to this issue?

IF(
USERSETTINGS(“Current_User_ACCT_GROUP”)=4,
SELECT(GL_ACCOUNTS[GL_ACCT_KEY],True),
SORT(
SPLIT(
TEXT(
SELECT(
USER_GL_ACCT_LINK[GL_ACCT_KEYS],
[USER_ID]=USERSETTINGS(“Current_User_ID”)
)
),
“,”
)
+
SPLIT(
TEXT(
SELECT(
USER_GL_ACCT_LINK[GL_ACCT_KEYS],
[USER_ID]=USERSETTINGS(“Current_User_ACCT_GROUP”)
)
),
“,”
)
+
SPLIT(
SELECT(GL_ACCOUNTS[GL_ACCT_KEY], [GROUP]=4),
“,”
)
)
)