I want to check for a certain piece of text in a cell and output its corresponding value.
| A | B | C | D |
|---|---|---|---|
| 1 | T1 | 45 | |
| 2 | T2 | 34 | |
| 3 | R1 | 75 | |
| 4 | R2 | 75 |
The idea is that in column D it outputs the value of C depending if B contains a "T" or an "R"
Later on, I want to calculate with these values.
Hope this makes sense.
>Solution :
As per your given conditions and the data sample in the OP, the following should work.
• Formula used in cell D1
=IF(OR(LEFT(B1)={"T","R"}),C1,"")
Using dynamic array formulas:
• Formula used in cell D1
=MAP(B1:B4,C1:C4,LAMBDA(α,φ,IF(OR(LEFT(α)={"T","R"}),φ,"")))