BoostExcel main content

Settings: In-cell Lookup - Invoice Manager for Excel

Click the Settings button on the Invoice worksheet to open the Settings window.

In-cell Lookup tab, Settings dialog box

The In-Cell Lookup feature allows you to retrieve a customer, a product or an invoice by typing the corresponding ID value right within the Invoice worksheet. For example, if you want to enter information about a product, which has an ID value of "345789", into the second line of the invoice body, all you need to do is to type "345789" into the "Product ID" cell on that line.

The in-cell lookup feature is also useful for users who use barcode as the product IDs. Simply activate/click the cell in which you want to place the product ID, and then scan the barcode as usual. You don't need to bring up the product selection box again and again.