I'm attempting to run the code below, but I get this worksheet function class error. Have tried many different ways, same error. Debugging shows Error 2042 on Range L1. Don't know what to do.

I am looking up the value in K1 in Dashboard worksheet - which is the number 1 in my Validation worksheet in cells B2:C13. The number 1 is in B2, and the value to be returned is in C2 = January. I want it to be shown in L1 Lon the Dashboard worksheet. They do exist.

Range("L1") = Application.WorksheetFunction.VLookup(Sheets("Dashboard").Range("K1"), Sheets("Validation").Range("B2:C13"), 2, False)


Any ideas appreciated.