Hi,

I am having a problem using an array to pull in duplicate values on a different sheet. This array worked when it was pulling values from the same sheet but now won't work when I try and pull values from a different sheet on the same workbook.

The array I am using: 
=(INDEX(TE!$B$5:$B$5000,SMALL(IF($B4=TE!$A5:$A5000,ROW(TE!$B$5:$B$5000)-4,""),COLUMN()-4)))