| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
make the cell hyperlink to any name within it
is it possible to make the hyperlink relevent to the text within a cell.
i.e if the cell said paul it would email to pauls email address or if the same cell said mark it would email to marks email address and so on. any ideas regards Hoyt |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
make the cell hyperlink to any name within it
Create a table with two columns, column A would be a name, Paul etc, column B would contain the equivalent email address from column A Select the range of data entered then choose Insert Menu and Name and enter a name for this range. Then use Data Sort (this function wont work unless the data is sorted into order). Highlight the cell you want say C2 and enter this formula =VLOOKUP(D1,TEST,2) If you enter a name in D1 the email address will appear in D2 Regards Special-K -- Special-K ------------------------------------------------------------------------ Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470 View this thread: http://www.excelforum.com/showthread...hreadid=562465 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
make the cell hyperlink to any name within it
Create a table with two columns, column A would be a name, Paul etc, column B would contain the equivalent email address from column A Select the range of data entered then choose Insert Menu and Name and enter a name for this range. Then use Data Sort (this function wont work unless the data is sorted into order). Highlight the cell you want say C2 and enter this formula =VLOOKUP(D1,TEST,2) If you enter a name in D1 the email address will appear in D2 Regards Special-K -- Special-K ------------------------------------------------------------------------ Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470 View this thread: http://www.excelforum.com/showthread...hreadid=562465 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How make hyperlink refer to cell content rather than cell address. | Excel Discussion (Misc queries) | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| Hyperlink a word within a cell | Excel Discussion (Misc queries) | |||
| Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel | |||
| How do I make a cell equal to another cells value and not it's fo. | Excel Worksheet Functions | |||
Linear Mode
