Hi,
Got this table:
...and would like this result:
If there is "X" in the cell, return value in 1:1. I have found multiple formulas to do so, but they only return first hit.
Anyone who can guide me in right direction on this one? Would appreciate it![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Got this table:
...and would like this result:
If there is "X" in the cell, return value in 1:1. I have found multiple formulas to do so, but they only return first hit.
Anyone who can guide me in right direction on this one? Would appreciate it
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)