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.
How to Use Excel's VLOOKUP Function. The Excel function VLOOKUP stands for vertical look up. It searches for a specified value in the first column of a table. It returns the value from the same row in a specified column of that table. VLOOKUP should be used instead of HLOOKUP when the comparison value is in a column to the left of the value to be returned. Here's how to use Excel's VLOOKUP function.