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).
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
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).
VBA Code:
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