VLookUp skipping empty cells

Alright, I'm new to VBA and just back from a three day class. This is my first program ever in any language so dont be harsh on me, haha.

So, I have two tables of data in two different sheets. They are financial time series, with the names of companies in the left most columns. I have written the following line of code that manages to find the row in which the company name appears, and get the data from the right column:

PHP Code: 


For i = 4 To 15

Worksheets("Differens").Cells(i, J + 1).Value = Application.VLookup(Cells(i, 1), Range("SAF"), K, False) - Application.VLookup(Cells(i, 1), Range("BUS"), L, False)
    
Next i

End Sub 


i j k l are all previously defined variables.

the cells (i,1) after VLookUp is the value that it uses to find the correct row. The problem is that sometimes it doesnt find the value, which is fine, because sometimes the companies havent submitted their data yet.

The question is though, how do I get it to simply skip that cell and move on to the next one? Right now I get an error message when I try to run the code and it stops at the row that has a name it cant find.

I'm familiar with pivot tables and believe me, it has to be done this way.

I'll check out .find

I got it to work, ignore this post.