Most effective way to insert vlookup formula?

[srosk]

I have a spreadsheet that I will be manually adding data to columns C:K. Periodically, I would like to run a macro that searches for rows where column C has a value, but column B is blank for that row. If column B is blank:

insert a separate formula in column A and column B for that specific row

Is this possible with VBA?

 

[DanteAmor]

I am not so sure I understand, so pardon my ignorance. If column C contains a value in any row (value could be any alphanumeric value)... then if column A is blank, insert column A formula for that row... and if column B is blank, insert column B formula for that row that was checked in column C.

Is this any bit helpful?

Thanks for all that you do!

Or try this:

Sub test_formula()
    Dim c As Range, lr As Long
    lr = Range("C" & Rows.Count).End(xlUp).Row
    For Each c In Range("B5:B" & lr).SpecialCells(xlCellTypeBlanks)
        If c.Offset(0, 1) <> "" Then
            c.FormulaR1C1 = "=VLOOKUP(RC[1],'A B'!C:C[2],3,0)"
        End If
    Next
    For Each c In Range("A5:A" & lr).SpecialCells(xlCellTypeBlanks)
        If c.Offset(0, 2) <> "" Then
            c.FormulaR1C1 = "=VLOOKUP(RC[2],'A B'!C[1]:C[3],2,0)"
        End If
    Next
End Sub

 

[MARK858]

Please see DanteAmor's post number 11 and not mine as he spotted that you have the condition if column C isn't blank which I missed (although personally I would cater for that in the formula and return a "")