The Lookup Wizard provides an easy way to create one or more TSLookup functions on the active worksheet.
The Lookup Wizard uses the following screens:
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.