Search for number in different column

[AlexPi]

I'm trying to summarize a P&L report taken from accounting software (later to be used in a pivot table, but need to get the data formatted) and I need some help using the search functions in excel.

Here is an example of the data which is imported into excel

A                   B 
1 4010 · Sales
2              4011 · Hardware
3              4013 · Audio Sales
4              4014 · Licensing

What I am trying to do is say something like IF(LEFT(B2,1)=LEFT(A1,1),A1,0)

Basically trying to search for the left most number in coumn B and return the heading that is in column A. There is missing data in Column A so I want the formula to use the next cell with data above it one column to the left.

I have tried using something like this but without much luck...

IF(ISTEXT(OFFSET(B2,-1,-1,1,1)),OFFSET(B2,-1,-1,1,1)/2,OFFSET(B2,-1,-1,1,1))

Anyone see any problems in the formula I am using or have any ideas?

Thanks for your help!

 

[AlexPi]

I ended up just using a bit of code to get this done...here it is in case someone needs this in the future...

Sub Fillinblanks()
For Each cell In Selection
On Error Resume Next
If cell.Value = "" Then cell.Value = cell.Offset(-1, 0).Value
Next
End Sub