Hi everyone,
I've resisted joining the office forums trying to figure things out for myself.
But I think this is an easy one.
I have sheet one which contains unique valuse in a colum
I have sheet2 which contains multiple valuses of each occurance ( which match the sheet1 colum) in one colum.

Eg sheet1 col B contains :
eggs
apples
oranges

Eg sheet2 colum B contains
eggs
eggs
eggs
oranges
oranges
oranges
apples
apples
apples

So the sheet2 colum has about 9000 entries whilst sheet one has about 900 unique values corresponding to values in sheet2.

I want to be able to click on a value in sheet one and after that click it will search sheet two and go to the first occurrence of that value in sheet2. I don't want to use buttons, but i need to simply click on the value in the cell and it will take me to that value in sheet2.
any help would be fantastic,
mike