[office src=”https://onedrive.live.com/embed?cid=582D5DCC719CEF3D&resid=582D5DCC719CEF3D%21272&authkey=ALGBG0Pbbmro0Iw&em=2&wdDownloadButton=True” width=”100%” height=””]
Excel sheet details about the contents, by column cell.
A Cell, NEWS
Shows: GNews Sodium oxybate Jazz Pharmaceuticals
Searches: Jazz Pharmaceuticals “Sodium oxybate” “pharmaceuticals”
Contains: =HYPERLINK(“https://www.google.com/search?num=50&biw=1280&bih=586&tbs=qdr%3Am&tbm=nws&q=”&$E2&”+%22″&$B2&”%22+%22pharmaceuticals%22”,”GNews “&$B2&” ” &$E2)
B Cell, INN
Shows: Sodium oxybate
Searches:
Contains: http://en.wikipedia.org/wiki/Sodium_oxybate
C Cell, Common Name
Shows: XYREM
Searches:
Contains:
D Cell, TYPE
Shows: narcolepsy cataplexy EDS
E Cell Manual Search Pharma Name
Shows: Jazz Pharmaceuticals
Searches:
Contains:
F Cell, Google Search
Shows: Google Sodium oxybate
Searches: what pharmaceutical company manufactures Sodium oxybate
Contains: =HYPERLINK(“http://www.google.com/search??num=3&q=what+pharmaceutical+company+manufactures+ “&$B2&”&safe=active”,”Google “&$B2)
G Cell, Dailymed Search
Shows: Dailymed Sodium oxybate
Searches: Ends up on page http://dailymed.nlm.nih.gov/dailymed/drugInfo.cfm?setid=926eb076-a4a8-45e4-91ef-411f0aa4f3ca
Contains: =HYPERLINK(“http://dailymed.nlm.nih.gov/dailymed/search.cfm?searchdb=all&labeltype=all&sortby=packager&page=1&pagesize=20&query=”&$B2,”Dailymed “&$B2)
H Cell, Pharma by xref
Shows: Jazz Pharmaceuticals
Searches:
Contains:=VLOOKUP(B2,’Largest selling’!$C$2:$F$122,4, FALSE)
– End of Page-