Excel vba vlookup multiple criteria
Step 2: Once you type the formula, copy the formula in cell c13 and paste it below or use the Autofill feature to copy the formula to the remaining cells until the #NUM! Appears. Step 3: Delete the #NUM from the table. In the above formula, D2: D11 is the column range in which you want to return the price values.