Challenge #19: Excel Record Locator

[mg46]

Tougher than I thought, but good Multi-Row Formula practice!

Spoiler

[dwstada]

solution

Spoiler

input only the specific cells and join via filename to create the table

[TungThanhHo]

my solution

[Tofel]

Spoiler

[Sebastian_Chaieb2]

Not sure if this is the desired solution, but here it is... :)

Spoiler

[DenisZ]

Here is my solution

Spoiler

[Eliot_Rich]

Thanks

[GGailly]

And here is mine !

[Sharod100]

Here is my solution

[NicolasSz]

Please see attached my solution.