Although the Help implies that this should work the fact is that MATCHALL, MATCHANY and MATCHCOUNT are "fuzzy" match functions.

MATCHALL does say

"This is an fuzzy match function, where a result may be returned if the match is close but not exact."

Try
Code:
FINDANY(trim({TrxAcct}), "16231", "16232", "16233", "16234", "16235...)





Edited by Andrew Bates (03/22/12 03:13 PM)
Edit Reason: Typo in func name