I am trying to use Index Match to replace Vlookup Function so my textbox displays date format. If I use Vlookup my textbox shows numbers. I tried the below code but it is not displaying the value in the textbox once I run the code. Can I please have your help to make the code work?
A column has my TBL value and I want to mach it with the value in column E
Dim TBL As String TBL= ComboBox7.Text On Error Resume Next Me.TextBox3.Value = Application.WorksheetFunction.Index(TBL, Sheets("PCARDatabase").Range("A4:A99"), Application.WorksheetFunction.Match(PCAR, Sheets("Data").Range("E4:E999"), 0), 1) End Sub