The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% Then, click OK or Apply button, all the matched values based on the multiple criteria have been extracted at once, see screenshot: (4.) In the Return column section, select the column which contain the returned values you need.ģ.Note: The number of columns selected in the Key column field must be equal to the number of columns selected in the Lookup Values field, and the order of each selected column in the Key column field must correspond one to one with the criteria columns in Lookup Values field.(3.) In the Key column section, please select the corresponding key columns that contain the lookup values one by one by holding the Ctrl key.(2.) In the Output Range section, select the output range where you want to put the matching results.(1.) In the Lookup Values section, specify the lookup value range or select the lookup value column one by one by holding the Ctrl key that you want to vlookup values based on.
In the Multi-condition Lookup dialog box, please do the following operations: Click Kutools > Super LOOKUP > Multi-conditiion Lookup, see screenshot:Ģ. Note:To apply this Multi-condition Lookup, firstly, you should download the Kutools for Excel, and then apply the feature quickly and easily.Īfter installing Kutools for Excel, please do as this:ġ.
0 kommentar(er)
