Create a hyperlink to matching string in another worksheet, same workbook

I was able to take the code from this thread (http://www.excelforum.com/excel-gene...ml#post4283066) and embed an additional INDEX and MATCH function to get a link that works to search for a matching string in another sheet, and take the user directly there upon clicking. Unfortunately, with multiple rows in the sheet with the links, every time I change a single HYPERLINK formula in a single cell, all the formulas in all cells of that column change to match it exactly - without taking into account the next row number.

I've recreated this sheet from scratch with only copying data over from the original (no formatting) and the problem persists.

The formula looks at data in column B of Sheet1, matches it to data in column A of SvcRepInfo, and then creates a link to take the user from Sheet1 directly to that matching cell on the SvcRepInfo sheet.

Please Login or Register  to view this content.

TEST hyperlink to matching string.xlsm

Works great! I'll need to spend some time on Mon researching your changes, but wanted to let you know that it definitely works as expected!