Index & match overlapping data

[MrSak87]

Hi experts

I have a set of velocity speeds for soils and rocks and I'm using an index and match formula for these speeds for data I'm importing. The formula is

=INDEX(H28:H45,SUMPRODUCT(--(I28:I45<=D7)*(J28:J45>=D7),ROW(I28:I45))-ROW(28:28)+1)

The reference table H28-J45 is shown below:

[TABLE="width: 288"]
<tbody>[TR]
[TD]Soft CLAY[/TD]
[TD="align: right"]40[/TD]
[TD="align: right"]75[/TD]
[/TR]
[TR]
[TD]Stiff CLAY[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]135[/TD]
[/TR]
[TR]
[TD]Loose SAND[/TD]
[TD="align: right"]135[/TD]
[TD="align: right"]240[/TD]
[/TR]
[TR]
[TD]Dense SAND & GRAVEL[/TD]
[TD="align: right"]240[/TD]
[TD="align: right"]355[/TD]
[/TR]
[TR]
[TD]Residual Soil[/TD]
[TD="align: right"]355[/TD]
[TD="align: right"]600[/TD]
[/TR]
[TR]
[TD]Metamorphic and Igneous rock[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RQD <50[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]RQD = 65[/TD]
[TD="align: right"]600[/TD]
[TD="align: right"]760[/TD]
[/TR]
[TR]
[TD]RQD = 80[/TD]
[TD="align: right"]760[/TD]
[TD="align: right"]1500[/TD]
[/TR]
[TR]
[TD]RQD = 90[/TD]
[TD="align: right"]1500[/TD]
[TD="align: right"]2500[/TD]
[/TR]
[TR]
[TD]RQD = 100[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]3400[/TD]
[/TR]
[TR]
[TD]Basement[/TD]
[TD="align: right"]3400[/TD]
[TD="align: right"]3600[/TD]
[/TR]
[TR]
[TD]Porous & saturated sandstone[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]1800[/TD]
[/TR]
[TR]
[TD]Limestone[/TD]
[TD="align: right"]2000[/TD]
[TD="align: right"]3300[/TD]
[/TR]
[TR]
[TD]Chalk[/TD]
[TD="align: right"]1100[/TD]
[TD="align: right"]1300[/TD]
[/TR]
[TR]
[TD]Granite[/TD]
[TD="align: right"]2500[/TD]
[TD="align: right"]3300[/TD]
[/TR]
[TR]
[TD]Basalt[/TD]
[TD="align: right"]2800[/TD]
[TD="align: right"]3400[/TD]
[/TR]
[TR]
[TD]Gneiss[/TD]
[TD="align: right"]2700[/TD]
[TD="align: right"]3200[/TD]
[/TR]
</tbody>[/TABLE]

The formula works....unless there are overlapping velocities. i.e if I'm returning a speed of 2900 the index & matched rock type could be Limestone, Granite, Basalt and Gneiss resulting in me returning an error. Is it possible for excel to somehow Concatenate these returned values into 1 cell or am I stuck with only being able to return one result?

Thank you for your time!