When I use a Vlookup function in VBA to search the record entry dates from a
range, it cannot find the record and just returns the run-time error. I am
sure that the particular dates exist in the range since I have used Countif
in VBA and Vlookup in worksheet to test if it exists. Could anybody tell me
why?

Price=Application.WorksheetFunction.Vlookup(EntyDa te,Sheets("Price").Columns("A:B"),2,0)

Thanks