I have a work sheet (worksheet 1) that has three columns of data and I want
to match it against another worksheet (worksheet 2) that has those same three
values in one column - if there is a match then i want to return a value in
column J of worksheet 2.

Worksheet 1:

Column D = 00001
Column G = 00000123456
Column H= 000123

Column T = Want value from worksheet 2 column J if all three above match

Worksheet 2:

Column I = 0000100000123456000123
Column J = 98765