RE: Using a Forall loop to compare cell values V J Adlam 29.Jul.11 07:36 PM a Web browser 1-2-3 All ReleasesWindows XP
A few points to clarify.
1) to use an @function "@Isempty (datacells)" in a script, you must use the EVALUATE function in the declarations section. (see Lotus Script Help). In this case you could use the IsEmpty script function instead of the @function.
2) With Analyze_First [(TABLE_C, A1...J1, A3 ... M3), are you wishing to see if any cell in either A1...J1 or A3...M3 match any cell in TABLE_C?
OR are you wishing to see if both ranges A1..J1 AND A3...M3 contain a match in TABLE_C? ie. both ranges must have a matching value/contents.
Both of these require different ForAll loop structures.
3) You probably could consider using a SELECT CASE block instead of the sequential and nested IF statements.