How do I "Index match" values that begins with desired value

Hi all,
Is it possible to Index(Match) a number that begins with a desired value?

I used "100*" in a formula to add all the numbers that begins with 100, but how do I do the same thing using index match?


Thanks

not sure if this is what you want, but give it a try....

=INDEX($E$3:$H$11,MATCH(LEFT($A5,1)&"*",$E$3:$E$11,0),MATCH($B5,$E$3:$H$3,0))

Thank you very much, it worked perfectly.

I made some modification to the excel file. The first file had some mistakes.

Thanks,

Happy to help and thanks for the feedback