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.
1. Know when to use Vlookup. Vlookup is a function in Excel that allows you to type the value of one cell to look up the value of a corresponding cell in the same row. 1  Use it to look up information from a large spreadsheet or if you have to find repetitive information.n the cell, enter this formula: =VLOOKUP(lookup_value, table_array, col_index_num, range_lookup). 1  You can use any cell to write this is, but remember that whatever cell you choose is entered as the âlookup valueâ in your function code.