Challenge #19: Excel Record Locator

[A_Twa]

My solution attached; thanks!

[MsBindy]

Yes, I can overcomplicate a ham sandwich.  Got there, but with all the condiments.

[robcarroll]

Solution. 

[DaveB]

A different approach.

[ADerbak]

Tried to do a macro and couldn't quite get it to work right, went with tiling and formulas instead.

Solution attached!

[nick_ceneviva]

Solution attached!

[jamielaird]

Here's my solution.

Edit: And yes, having looked at others I'm kicking myself for not doing the selection with a single formula tool - doh!

Spoiler

[patrick_digan]

Spoiler

[Natasha]

Looking at other solutions, I guess I could do without a transpose.

Spoiler

[data_rachel]

Spoiler