Hello,

I am struggling - I basically need a formula in one tab of a spreadsheet that if another cell contains text it will search for that text in another tab and display a useable hyperlink to it.

So I want a formula in A1 in Sheet1 that will search for the text contained in A2 in Sheet2 and display a useable hyperlink to the cell in which that text is contained, in Sheet2.

This may not even be possible, but if it is then that would save me SO much time.

Thanks in advance for your help guys.

Daniel B