Get Vlookup formulas written quickly and painlessly, without having to learn the syntax and numerous specificities of the Excel VLOOKUP function. An intuitive wizard will guide you through the formula building process and help you define the arguments. As the result, you get a formula that is the best fit for your particular data.
Excel VLOOKUP Wizard is a one-step utility to pull matching values from another table located in the same or different Excel worksheet or workbook. You just select your main and lookup tables, specify the lookup and return columns, and have an impeccable Vlookup formula inserted in your worksheet with no additional efforts.
VLOOKUP Wizard does not use any custom functions, only native ones. Depending on which columns you select for the arguments, the wizard chooses the function most appropriate for your particular data. Thus, you get a robust Vlookup or Index/Match formula and learn some valuable tips about the formula syntax along the way. Win-win!
Easily :) Select a cell in your main table, start the add-in and fill in the following boxes:
Once the argument boxes are filled in, click the Insert button. Optionally, select the Back up the worksheet checkbox (recommended for the first use of the wizard). A new column with Vlookup formulas is inserted next to your key column, saving you the trouble of copying the formula manually.
Please find more information here.
Yes. If your columns have headers, just tick off My table has headers checkbox, and you will be able to select the columns by their headers.
Yes. Our VLOOKUP Wizard for Excel doesn't care where your lookup column is located. In situations when you need to vlookup to the left, you can select which result formula you’re going to get: an Index/Match combination or Xlookup. Both can search anywhere.
No. Like all regular Vlookup formulas, the formulas built by the wizard are case-insensitive.
No. Sorting the lookup column in ascending order is only required for Vlookup with approximate match. Our wizard always makes Vlookup formulas with exact match (FALSE in the range_lookup argument), which do not require sorting the lookup column.
Personal | Business | Business, 5 seats | |
One-time purchase You pay only once and can use the purchased version as long as you need. |
|||
Unconditional 60-day money back guarantee If you are not 100% happy with the product, you can cancel an order and get your money back with no questions asked. |
|||
Volume discounts
|
|||
Support for Excel 2019 – 2010 All Excel versions 2019–2010 are supported, both 32- and 64-bit. Also, all desktop Excel versions included in Office 365 subscriptions. |
|||
Free upgrades for 2 years During 2 years after the purchase you get all minor updates and major upgrades for free. |
|||
License for | Single user | Single user | 5 users |
Technical support service Our support team is always happy to help you via email, live chat, or phone no matter how long ago you purchased your license. |
|||
Corporate deployment (GPO, SCCM) Your system administrator can quickly and easily deploy Ultimate Suite for a group of users without even disturbing them. |
|||
Features and hotfixes on request We’ll do everything in our power to create additional features you need and fix the found bugs as soon as possible. |
|||
July Offer
Enjoy Ultimate Suite
with up to 30% discount Offer ends July, 10th
|
$69 $99 Buy now |
$11995 $14995 Buy now |
$29996 $375 Buy now |