Forum Discussion
Find a row within a column range.
Geir,
On your latest screenshot in column C are only "X":s, perhaps you mean column D (Column3 of the table). In wanted result on it are also not correct.
The question is what to return if no one record with (AA) or like in Column 1 and with (select) in Column3 - these are AB, AC record in current sample.
Thank you SergeiBaklan alsmost. The problem is that the first one is selected. What I want is to display the text with "Select" from column C. So here the resulte should be "A red apple (select)"
- Geir
Geir,
On your latest screenshot in column C are only "X":s, perhaps you mean column D (Column3 of the table). In wanted result on it are also not correct.
The question is what to return if no one record with (AA) or like in Column 1 and with (select) in Column3 - these are AB, AC record in current sample.
Perfect SergeiBaklan That made it. This is one test within an IFS. So the other rows is filled by other tests.
Thank you, And have a nice weekend.
- Geir
You too Geir, glad to help