Selecting multiple fields will cause multiple TSLookup functions to be created. The first formula is placed into the active cell, overwriting any existing contents. Subsequent formulas are placed in adjacent cells to the right. There is no way to undo inserting a new formula, so make sure that you have enough room for your formulas before entering them.
"In today's economic times, it is imperative that we are confident in the information we provide to our company and our customers. To achieve this, we rely on Office Connector. Office Connector enables Excel to instantly gather and write information that would otherwise take hours or even days to assemble."