Hyperlink using Vlookup

[rwood1989]

I'm trying to link one sheet to another using a hyper-link, however there are thousands of hyperlinks to do so I'm thinking the best way is some sort of automation.

I have one work sheet with a list of invoices numbers and various details, my other sheet has invoice numbers and other details about them but the second sheet is automatically created in such a way that it cant be organised in a way that I could merge the two.

So when I click an invoice number I need it to lookup that invoice number on the other sheet and take me to it.

Any help would be great

Thanks!

[NBVC]

Something like this?

=HYPERLINK("#"&"'Sheet2'!"&ADDRESS(MATCH(A1,'Sheet2'!C:C,0),3),"Click")

This looks for the item you have in A1 of the active sheet, finds it in column C of Sheet2, and provides link. Click the hyperlink to take you to that item in column C of sheet2.