Xlookup error

[gheyman]

Here is what I am using but I get a Run Time Error 1004
Method 'Range' of object'_Global' failed

Sheets("Cost Sources").Range("AC" & TPLR).Value = Application.WorksheetFunction.XLookup(Sheets("3 Enter Quote Data").Range("F5"), Range("Selected_Vendors[Name]"), Range("Selected_Vendors[SharePoint URL.[MF] Path/Location]"), "X", 0, 1)

Thanks

 

[gheyman]

My error - misspelled table name