The data columns containing the data to be returned if there is a match on the IDs. The Lookup Assistant will concatenate the columns. The cells containing the identifiers to be looked up. The Lookup Assistant prompts you for the following information: You are given the option of either loading matching values, inserting a simple formulas (ex: =F23), or a VLOOKUP formula to the matching data. If you have a price list of product numbers and prices in one worksheet and in an invoice worksheet you just have product numbers, the Lookup Assistant will match the numbers in the invoice to those in price list. Mark Babb who purchased the Lookup Assistant and Cell Color Assistant wrote: "Your products are WONDERFUL! I have used Excel since it was Lotus and Quattro and you have really made it easy to use the built-in functions with your clever front-ends. I then spent over an hour trying various programs that offered a quick fix for my problem but none of them met the exact criteria until I found Lookup Assistant - within 15 minutes of installing the add-in I had completed the database restructure! I can't thank you enough for this excellent addition to Excel!" Regarding the Lookup Assistant, Mark Reid told us: "After 18 hours of wading through 6,000 lines of a 40,000 product database I had almost given up entirely. It is compatible with Microsoft Excel 2010-2021 and Office 365. The Lookup Assistant add-in for Microsoft Excel is designed to find or lookup matching data in one list and load in another.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |