Hello,

Wondered if anyone could help. I wanted to convert the following formula into VBA code but I think I may done something wrong.


FORMULA:

=INDEX('PPG DATASHEET'!$J$2:$J$30000,MATCH($D$1,'PPG DATASHEET'!$B$2:$B$30000,0))


VBA CODE
lblDescription.Caption = Application.WorksheetFunction.Index(Sheets("PPG DATASHEET").Range("J2:J30000"), Application.WorksheetFunction.Match(txtMDMcode.value Sheets("PPG DATASHEET").Range("B2:B30000"), 0))
The value I am trying to match instead of cells D1 is in txtMDMCode.Value.

Appreciate the help