Need a formulae which will do the following
1. Concatenate value in cell D1 and upper most value in cell D7, and
2. create an hyperlink in cell D7 to location 'sheet'!2B3
3. Cell D7 will have formulae which generates value 'jhj'
4. for expample what appears in cell D7 will be as follows: ="b3"&" "&formulae which give bring the value of 'jhj' which is generated as a result of formulae in other sheets
Kindly see if there is possibility of providing an excel based formulae.