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.
2) Using CHOOSE to recreate the Table Array for VLOOKUP. This is a bit advance. The tricky part is to re-create the Table Array that is suitable for VLOOKUP by using CHOOSE. CHOOSE({1,2},B2:B10&C2:C10,D2:D10) does two things. Combine âMonthâ and âStoreâ into a single array as âJanTWâ;âFebTWâ, etcâ¦â¦.