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>
Column A...