I'm trying to go from the top formula to the bottom one. I have to match H9 (which is a string of 8 characters) to column A which has the same set of information as in column H but with an added number at the end. So I need to be able to match H9 to the leftmost 8 characters in column A. I tried to use an array formula as shown in the example below but it doesn't seem to work. What can I adjust in order for this to work out?

=INDEX($A$9:$B$1000,MATCH(H9,

**$A$9:$A$1000**,0),MATCH(I$8,$A$8:$B$8,0))

={INDEX($A$9:$B$1000,MATCH(H9,

**LEFT($A$9:$A$1000,8)**,0),MATCH(I$8,$A$8:$B$8,0))}

Thank you!