Good morning. I currently have 3 sheets. Sheet3 B40 = Lookup_value. Sheet 2 F4:H34 = Table_array. 3 = Col_index_num, and 0 = Range_lookup. Sheet1 J14 = the value I want pasted. Here is my question, issue. I want the date from Sheet3 to Vlookup the correct cell from Sheet2. I then want the value from Sheet1 J14 copy and pasted into the Vlookup cell. Below is what I was working on, however, I can't seem to get it to work. Once I can make this work, I want to be able to control this with a button that will post the value, and not the formula that is in J14. I want the information to be static. Help please.

Sub test()

Application.WorksheetFunction.VLookup(Worksheets("Sheet3").Range("B40"), Worksheets("Sheet2").Range("F4:H34"), 3, 0) = Worksheets("Sheet1").Range("J14").Value

End Sub