Despite 56400 being RIGHT THERE in the list, it cannot seem to find it.
I’ve been grappling with this all morning. I tried to recreate it in another app and it worked perfectly so I really hope I have just done something stupid here and someone will (gently) point this out to me!
Hi Briani, thanks for the response. The first entry is in fact “56400” - look at the blocks.
The reason for the " - " is that I have set the label to display the entry it is searching for followed by the " - ", followed by the list, followed by the number of ties it has found that entry.
You’re right. You need to compare text to text. You’re comparing a number to a text string. Join the 56400 number to an empty string (“”) to convert it to a text string when assigning it to the variable. Even though it makes sense to our brains, 56400 ≠ “56400”.