Challenge #19: Excel Record Locator

[Jur]

My solution:

Spoiler

[Niklas]

Almost got it to work completely with dynamic input but had to go for a work-around to append the sheet names 😕

[SophiaF]

Multi-row Formula!

Spoiler

[FRANCK_ROUQUETTE]

Thank you for the exercise - please find attached my proposed solution.

[LukaszKarpinski]

Hi! My solution in the attachment,

Kind Regards,

Łukasz

[ConradW]

19- complete

[SarkaHubacek]

I decided to take this challenge as an opportunity to learn as much as possible, so I tried different approaches showed here.

Spoiler

[Tom_Luthi]

solution attached.

[viveknshah]

Spoiler

Pretty similar to other approaches looks like, only I used ordinal ordering like arrays so had to go with 1 and 7 instead of 2 and 8. 

[Inactive User]