Challenge #19: Excel Record Locator

[aihnen]

Solution attached.

Spoiler

[Normster]

I took a longer path but got to the same destination.  

Normster

[AmeliaG]

Spoiler

[Kakuffo]

This took me longer than it should have. First time using the  Multi-row Formula!

[razziagafur]

At first thought it was quite difficult for a beginner, but once I broke it down I realised it only took a few simple tools. Needed to see in comments that the row number was one less than I thought the message indicated.

[JamesCameron]

My two efforts. The first is a brute force version, the second trying out something along the lines of the provided solution.

Spoiler

Effort 1

Effort 2

[Nicholas_Bignell]

nice and quick

[Nic_Morales]

Solution attached

[hcoutts]

Spoiler

Spoiler

[danicahui]

Spoiler