Media caption'Female Viagra': Explained in 60 seconds. The US Food and Drug Administration has approved a libido-enhancing drug for women dubbed the female Viagra. Flibanserin, a drug produced by Sprout Pharmaceuticals and marketed as Addyi, recently passed an FDA advisory committee meeting. It has been criticised as having only marginal benefits.
Hack #75. Use the VLOOKUP Function Across Multiple Tables. Although VLOOKUP itself is very handy, it is restricted to looking in a specified table to return a result, which sometimes is not enough. You can escape this limitation with the INDIRECT function. Sometimes you might need to use a single VLOOKUP formula to look in different tables of data set out in spreadsheets.
Excel's VLOOKUP function, which stands for vertical lookup, can be used to look up specific information located in a table of data or database. VLOOKUP normally returns a single field of data as its output. How it does this is: 1  You provide a name or Lookup _value that tells VLOOKUP in which row or record of the data table to look for the desired information. 2  You supply the column number - known as the Col_index_num - of the data you seek. 3  The function looks for the Lookup _value in the first column of the data table.