VBA INDEX MATCH Application to display value in Textbox

[YingFa]

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?

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

A column has my TBL value and I want to mach it with the value in column E

Thank you.

 

[DanteAmor]

You could explain with a simple example:
- What do you want to look for?
- Where are you going to look?
- And what do you want as a result?