On Sheet Test I want a formula that looks at whatever is in G1 on Sheet Test and find this in Sheet 'Other' in E1:T20000, and return whatever is in col H where it is found, BUT there may be numerous instances of this word and therefore I only want it to return a result if sheet 'S' E15 matches sheet 'Other' col D on the row where the match is found.