Hi
I have a dataset of 200 rows.
Each cell has multiple lines, I want to write a formula that finds the line which has a specific word, and then get the corresponding value from the cell next to it. Is that possible?
Row 1:
Cell 1 Cell 2
A v
B d
C e
Row 2:
Cell 1 Cell 2
B d
C e
I want to find the vals (d) from cell 2 based on cell 1 (B)
Is this possible?
I have a dataset of 200 rows.
Each cell has multiple lines, I want to write a formula that finds the line which has a specific word, and then get the corresponding value from the cell next to it. Is that possible?
Row 1:
Cell 1 Cell 2
A v
B d
C e
Row 2:
Cell 1 Cell 2
B d
C e
I want to find the vals (d) from cell 2 based on cell 1 (B)
Is this possible?