Formula to return the preceding cell which has a text string.

[oscark37]

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?

Column A	Column B
	AOF010
	112823
	BEL023
	12121
	323232
	1321212
	JEF233

<tbody>
</tbody>

​
Thanks,

Oscar

 

[Marcelo Branco]

Maybe...

	A​	B​
1​	Formula​	Values​
2​		AOF010​
3​	AOF010​	112823​
4​		BEL023​
5​	BEL023​	12121​
6​	BEL023​	323232​
7​	BEL023​	1321212​
8​		JEF233​

Formula in A2 copied down
=IF(ISNUMBER(B2),LOOKUP(2,1/ISTEXT(B$1:B1),B$1:B1),"")

M.

 

[oscark37]

Absolutely perfect!

Thank you!

 

[Marcelo Branco]

You are welcome.

M.