Challenge #19: Excel Record Locator

[catarina_pimpao]

Spoiler

[mbonora]

Basically the same as the provided solution.

[johnemery]

This one was trickier for me than I thought. My first time using a wildcard in the input tool, and first time using function(s) in that manner. All very good practice and learning experiences!

Spoiler

[DavidThorpe]

My solution, tried it with dynamic input but simplified - used wildcard and specified cell ranges:

Spoiler

[mmccowin]

I know I am super late to the party but I didnt find this to be particularly easy... Probably just because I am not as familiar with some of these techniques.  I pasted below what I came up with.

[CamodCPA]

This is a good way to learn the different ways to create unique identifiers! personally, I love how easy it is to use TILES.

[RolandSchubert]

My solution

[RichoBsJ]

Hi! Here my solution :)

[AJauniskis]

My take on this using Directory tool:

Spoiler