Easily Vlookup with multiple criteria in Excel
Kutools for Excel
Boosts Excel With 300+
Normally, you can apply the Vlookup function to lookup the corresponding data in a list based on a specific criterion, but, sometimes, you may need to vlookup the relative value based on multiple criteria as below screenshot shown. If you have Kutools for Excel, with its Multi-condition Lookup feature, you can lookup the matched values in different columns based on multiple criteria with only several clicks in Excel.
To lookup the corresponding values from multiple different columns, please do with the following steps:
1. Click Kutools > Super LOOKUP > Multi-condition Lookup, see screenshot:
2. In the Multi-condition Lookup dialog box, please do the following operations:
B. If the key columns are contiguous and match the order of the Lookup values, just select the entire range of them.
Then all the matched values based on the multiple criteria have been extracted at once, see screenshot:
To replace this #N/A error value with another text value, you need to click the Options button to open Options dialog box, check the Replace #N/A error value with a specified value option, and then type the text you need, if you want to display #N/A as empty, just leave blank in the textbox.
You can see the #N/A error is replaced with the specified text as shown in the screenshot below.
The following tools can greatly save your time and money, which one is right for you?
Office Tab: Using handy tabs in your Office, as the way of Chrome, Firefox and New Internet Explorer.
Kutools for Excel: More than 300 Advanced Functions for Excel 2021, 2019, 2016, 2013, 2010, 2007 and Office 365.
The functionality described above is just one of 300 powerful functions of Kutools for Excel.
Designed for Excel(Office) 2021, 2019, 2016, 2013, 2010, 2007 and Office 365. Free download and use for 30 days.