Does this require a vba code?

[Haydo]

or is there a function that allows me to...

click on a name in column D, in a worksheet named 'First Base'

and automatically arrive at the corresponding name in column A, of another worksheet (named 'sheet5') in the same workbook.

It is the same as copy+pasting into a Ctrl-F, but there are lots of entries of similar names in this whole workbook, and it would be a big time-saver to go straight to the first entry in col A of 'sheet5'

There are several entries of each name in Column A of Sheet5, but i only require the link/hyperlink etc to arrrive at the 1st entry (searching down the column.)

Any ideas? Thanks.

 

[wigi]

A first example that works on my PC with a file called Book1.xlsx on the C: drive:

=HYPERLINK("[C:\Book1.xlsx]Sheet5!A" & MATCH(E6,'First Base'!$A$1:$A$5,0),"Jump")

E6 is the cell with the contents to be looked for, A1:A5 is the range of cells in which of look.

 

[Haydo]

=HYPERLINK("[C:\Book1.xlsx]Sheet5!A" & MATCH(E6,'First Base'!$A$1:$A$5,0),"Jump")

Thanks for your post.

Where do i put this function?

I have tried a few things, without success.

I have changed the name (book1) to the book i am using, but i would like to know exactly what to do with it.

What cell do i put it into? Do i have to add this function to each of the cells in the respective columns of either worksheet.

Thanks.

 

[wigi]

What cell do i put it into? Do i have to add this function to each of the cells in the respective columns of either worksheet.

In any cell you like, it will create the hyperlink so you can click on it just like a regular hyperlink.

File names, the path, the ranges, ... you have to adapt to suit but based on your information I would say that this formula is already close to the end result.