Error Handling in VLOOKUP with VBA

[sahaider]

Hello ,
I have the following VBA code that includes VLOOKUP.

I am trying to include error trapping in the code so that when Vlookup returns #N/A write the code writes "Missing" in those cells.

lastRow = Worksheets("LTE_Best Server by RSRP").Cells.SpecialCells(xlCellTypeLastCell).Row
With Worksheets("LTE_Best Server by RSRP")
For r1 = 2 To lastRow

.Range("G" & r1) = Application.WorksheetFunction.IfNa(VLookup(CStr(.Range("F", r1)), Worksheets("ALL 4G Hierarchy").Range("E2:J125000"), 5, False), "Missing")

Next

End With

But i am getting Sub/Function not defined for VLOOKUP when I run the code.

Can't figure out what is wrong in the code.

 

[Fluff]

See posts 8 & 9, Peter already spotted the problem & I've corrected it in post#9

 

[Peter_SSs]

That gives us nothing to go on.

In what way did it fail?

In this case there is no need to answer that as I can see my error. Try Fluff's latest code.

 

[sahaider]

In this case there is no need to answer that as I can see my error. Try Fluff's latest code.

thanks Peter, yes Fluffs code did work. I will thanks Fluff too separately

 

[sahaider]

See posts 8 & 9, Peter already spotted the problem & I've corrected it in post#9

thanks. it now works

 

[Fluff]

Glad we could help & thanks for the feedback.