VLOOKUP Formula Wizard is a single-step tool that quickly matches and pulls the necessary values from another Excel worksheet. It gives you the possibility to insert INDEX/MATCH or VLOOKUP formulas into your main table. There are just 5 simple fields where you specify your tables and columns, and you are a click of a button away from the results.
Open both spreadsheets you are going to work with: your main one where you want to insert the results as well as the worksheet that has the matching and resulting values.
Pay attention to the Back up the worksheet option. We recommend keeping it selected as Excel doesn't let you cancel changes made by add-ins.
To run the add-in, go to the Ablebits Data tab and click the Vlookup Wizard icon in the Merge group:
Adjust your options on the Vlookup Wizard pane:
The Your table has 1 header row checkbox is ticked by default to help you find the right key column. If your table has no headers, uncheck this option and you will see the list of columns as they are named in Excel (Column A, Column B, etc.)
Click Insert to get the formulas that retrieve the values you need. The add-in will insert VLOOKUP, XLOOKUP, or INDEX/MATCH functions depending on what your data require and your choice.
My Ablebits doesn't have " XLookup instead of Index & Match". What is Xlookup and how do I update to get this feature?
Thank you for contacting us. To learn more about Xlookup, please have a look at our detailed blog post:
Excel XLOOKUP function with formula examples
Also, make sure to download and install the most recent version of Ultimate Suite using the link below:
Then run VLOOKUP Wizard and check if the Use XLookup instead of Index & Match option appeared in the pane. Thank you.
Hi, Is it possible to look up several columns on once and have several columns of returns? For example: I have columns A, B, C and I need to find the matching values in column G for each columns then have the results for each column instead of doing each column separately. Thank you
Sure, I can find a solution for you. Yet, I need to know how many sheets you have and the way your data is arranged. Please send me a small sample workbook to email@example.com with: 1 - your source data and 2 - the result you expect to get. I kindly ask you to shorten the tables to 10-20 rows.
Note! The result sheet is of great importance and often gives us a better understanding of your task rather than any text description. Please don't forget to include it. Thank you.
I have Abblebits and use the vlookup wizard often. However, I would like to have the results go to an existing column instead of inserting a new column. Is this possible? if so, how?
Unfortunately, it is not possible to insert the result into an existing column in the current version of the add-in.
My lookup is returning #NA but I can manually find the value I'm searching for and the formula wizard appears to be work.
Thank you for your comment. I am glad VLOOKUP Formula Wizard has helped you. If you experience any problems with Excel formulas, please do not hesitate to contact us with a detailed description of your task, we’ll be happy to assist you.
In trying to use the Vlook up wizzard, The "look up table" box will not grab the proper name of the look up sheet. It only wants to reference the main sheet. It does not pick up the "name" of the sheet just the fields of the main sheet.
YI there also is no "expand" selection" button as mentioned in the tutorial.
What am I missing
Thank you for using our product and for your comment.
It looks like you have an old VLOOKUP Wizard version. Please upgrade your Ultimate Suite for Excel using this link:
If this won’t help, please contact our support team at firstname.lastname@example.org.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!