I have two arrays, one small one big.
The user picks a Name from the big array. The system compares that name against the Names in the small array. If the Name is in the small array it returns a value of 1, if its not it returns a value of 2.
Or at least its supposed to...
I have set this up two different ways.
#1 using an Array loop
#2 using a System.For loop.
Setup #1 will return a value of 1 only on the -last- X item from the small array. All other items that match do not return a proper value. I've tried both with and without the TriggerOnce sub shown in the image.
<img src="https://dl.dropboxusercontent.com/u/39000273/First%20Way.png" border="0" />
Setup #2 will return a value of 1 only on the -first- item from the small array. All other items that match do not return a proper value.
<img src="https://dl.dropboxusercontent.com/u/39000273/Second%20Way.png" border="0" />
User selects from ListB:
Manly - return value 2
Silly - return value 1
Scared - return value 2
Sassy - return value 1
Currently I can get a value of 1 on Sassy or Crazy but not Silly... any cell between the first and last I can't get a proper value returned!