Guys I m using the below fuction to check:

• If a value included in a table column (Match)
• Get the value from the table (VLookup)

Unfortunately, I getting error in both formulas.

tblCompanyDetails it’s table name.

VLookup formula

CompanyNumber = Application.WorksheetFunction.VLookup(CompanyName, tblCompanyDetails, 2, False)

Error
Unable to get VLookup properties.

Match formula

InScope = Application.WorksheetFunction.Match(CompanyName, tblCompanyDetails[Company Name], False)

Error

Syntax error

Any help will be appreciated.