Does anyone have a formula for finding certain text and the info in a cell below. I use the formula in D1 to find certain text and the info to the right of. It works for rows but I can seem to doctor it to work in columns.
i.e. I want to be able to find "Prev Close" and then whatever is in the cell below.
<tbody>
</tbody>
i.e. I want to be able to find "Prev Close" and then whatever is in the cell below.
a | b | c | d | e | |
1 | Prev Close | =INDEX(A:A,MATCH("Prev Close ",$A:$A,0)) | |||
2 | $43.00 | ||||
3 |
<tbody>
</tbody>
Last edited: