Applying IF function to a custom vlookup formula

Hi everyone,

THis one might be a bit tricky. Using VBA code if found on the internet, I've created a custom vlookup VBA for cells over 255 characters:

=MyVL(AM3,PA!$L:$Y,13)

The macro code is:

Function MyVL(v As Range, r As Range, os As Long) As Variant
Dim cl As Range

For Each cl In r.Columns(1).Cells
If v = cl Then
MyVL = cl.Offset(0, os - 1)
Exit Function
End If
Next
End Function

What I need to do is add an if statement which will sure cell to the left the cell with the MyVL formula. What I need it to do is return a BLANK value if the cell to the left of the one with the formula is either a 0, blank or #REF!. Any ideas?

Hi Chemist,

Thanks very much. I tried your formula but it blanks out all cells, even ones with adjacent values in them. Now, the adjasent cells have text values because of a vlookup in them. Would that make a difference?