Lookup formula

[deejabram]

I am having a difficult time trying to find a formula to complete a certain function.

I have a Value on one tab of a workbook. I want Excel to find that Value in other tabs (I have no idea which row or column the value may appear in the other tabs).

I would then like to insert a hyperlink on the Original Value, linking it to the Matching Value. I am fairly sure I would have to insert the hyperlink myself, which is fine, but I am having a hard time thinking about the easiest method to find that Value (short of the Find Function).

Any help would be greatly appreciated.

[wmfinance]

You could always use a vlookup/hlookup to find the value you want and hyperlink it where the tab.