Combination IfNa, VLookUp and loop (For Next) in VBA

[dzifna]

Hi!
I try to explain my problem very quickly:
I need to use formula VLookUp in VBA, but I have two ranges (two tabels). To simplyfy my work, I use IfNA in a simple loop (For Next).

Sub VBA_runda1_alter()

x = 1
For x = 3 To 12
    Cells(x, 4).Value = Application.WorksheetFunction.IfNa( _
    Application.WorksheetFunction.VLookup(Cells(x, 2).Value, [table_1], 3, 0), _
    "No decription")
Next x
End Sub

It works only for first range, after that it doesn't show any information.

Also, when i use the same method to the next loop, it doesn't show anything. I think it'a a problem with IfNA formula.

Any help, please? Thanks

 

[Joe4]

Welcome to the Board!

It works only for first range, after that it doesn't show any information.

Your code only includes the first range.
If you want it to bounce to the second range, then you would need to replace the part of your code that says "No description" with another VLOOKUP formula.