| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.links
|
|||
|
|||
VLOOKUP RESULTS AS A HYPERLINK
Hi Bill,
Thanks for reply I have just tried it but still no luck. I have done the VB function and then copied the formula you told me and in cell it says #NAME? =HYPERLINK(GetHyperlink(INDEX('LOOKUP LOG'!A2:A1501,MATCH(C15,'LOOKUP LOG'!A2:A1501,0)))) Any thoughts. Regards Bill Manville wrote: Alt+F11 to VB editor Insert Module Paste the code into the code window that will appear top right Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...links/200806/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vlookup results in 0 | Excel Discussion (Misc queries) | |||
| Vlookup with two results | Excel Discussion (Misc queries) | |||
| answer to odd results when comparing hyperlink addresses | Links and Linking in Excel | |||
| Can I have mulitple web page results from a Hyperlink? | Excel Discussion (Misc queries) | |||
| How do I annotate the cell results from Excel to a Hyperlink? | Excel Discussion (Misc queries) | |||
Threaded Mode
