Forum Discussion
Find a row within a column range.
Hi
The challenge: Function return "The fruit is apple (select) if (AA) in column 1
Or how to use Xlookup (or any other function) to make a selection in the table, and return value from a second column
I have tried with Xlookup and Xmatch, but it returns #Value
=XLookup("*"&RIGHT[@[Column 1]];4)&"*";[Column 1];XMATCH("*Select*";[Result];2;1);"";2;1)
Best regards
- 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.
5 Replies
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.
