Challenge #19: Excel Record Locator

[Caesar]

 Solved, with a bit of tinkering with the Multirow Formula tool.

[kcfuiks]

I had to add a formula in the beginning because I renamed the .xls files. Made a system that would account for future files as long as the common sheet stays the same.

[VizChic]

FG Alteryx Adventure solution

[mneun815]

My solution.  Probably took a few extra steps but I got there.

[DanTh]

Spoiler

My solution was overly complicated, but relatively simple to put together. The Formula + Summarize combo is very tidy.

4/5

[Drvt6713]

Challenge 19 Solution

[dbmurray]

Woohoo completed! Same as the solution

Spoiler

[Freddy123]

Spoiler

[MatthewBr]

Interesting use case for companies that need to grab specific values from cells in different sheets.

[kajan22]

...