I have a column B which has a mix of numbers and text. I want to put a formula in column A that when there is a number in column B of the same row, returns the next cell moving upwards that starts with text.
For example, the formula in A6 would return BEL023.
Any ideas?
<tbody>
</tbody>
Thanks,
Oscar
For example, the formula in A6 would return BEL023.
Any ideas?
Column A | Column B |
AOF010 | |
112823 | |
BEL023 | |
12121 | |
323232 | |
1321212 | |
JEF233 |
<tbody>
</tbody>
Thanks,
Oscar
Last edited: