LinkBack URL
About LinkBacks
You need to join the strings together with the ampersand:
=IF($B2<>"",HYPERLINK("https://.../Search/QuickLink.aspx?n="&$B2&"&t=3&d=Main%5ceBProd&sc=Global&r="&$C2&"&cno=E_SOURCE&m=l","Open"),"")
Hope this helps.
Pete
You need to join the strings together with the ampersand:
=IF($B2<>"",HYPERLINK("https://.../Search/QuickLink.aspx?n="&$B2&"&t=3&d=Main%5ceBProd&sc=Global&r="&$C2&"&cno=E_SOURCE&m=l","Open"),"")
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks