Formula for index match if two different lengths

I'm using index match to match an id from one worksheet1 to worksheet 2 and populate the field worksheet 1 (ROW H). However, the index match isn't working for the entire array--I'm guessing it's because of the different lengths?? Is there something else I can do?

Show the actual Index/Match formula that you are using to populate Column H in worksheet 1.

This works for me

=INDEX(Worksheet2!H:H,MATCH(worksheet1!D2,Worksheet2!D,0))