Yes, I understand that it is a one-to-many and the key is the unique values on the first sheet. What I don't understand is what identifies that first record on the second sheet. Is there nothing special about it other than its position? Is it first because its oldest or newest?

I understand you want to click a record and then go to the first record on the second sheet that matches it. What I'm trying to figure out is if there's an alternative solution to that. That will require code for sure. But its possible we may accomplish what you want in some way that does not require code.

Using your example, you have the record 'eggs' on the first sheet. On the second sheet there are multiple records of eggs. Why? Because these are inventory bins. Each bin has lots of information such as capacity, quantity on hand, etc. And each bin has a date that the eggs were laid and for apples when they were picked, etc. This is important since we want to maintain FIFO.

So the second sheet (in my completely made up fantasy world) has a structure of:

Column A: Item (eggs, oranges, apples)
Column B: Date picked, laid, harvested, etc.
Column C: Capacity of the bin
Column D: Current on hand quantity of the bin

The data are ordered by Item then Date so the first record in the sheet for each item is the oldest one. So you say, hey, it would be nice to just go click eggs on the first sheet and have it take me to the first record on the second sheet so I know what bin to go to to get the eggs that have been sitting on the shelf the longest.

Then I say, how about we just have another field on the first page that gives the bin number of the first record because that's what's really important? It's easily done and doesn't need any coding.

You say, that's great, but can we also get the date and the quantity on hand too.

I say sure, no problem, in fact, we can get any information you want in that record just so long as we know which record you want i.e. the oldest record. Why don't you head over to the pub for a beer and I'll meet you there in 10 minutes after I finish this?

You say, that's nice, but I'd rather do the clicking thing.

I say, whatever you want. Give me a couple days.