How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array

		Microsoft Office Forums > Microsoft Excel > Excel
How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array

FAQ

Thread Tools

Display Modes

01-20-2018, 11:36 PM

xor

Windows 10 How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

If you name your ranges in column B, F and K in Picklist:

Helper
Container.Name and
Price.point

then try the following array formula:

=IFERROR(INDEX(Container.Name,MATCH($B$2&":"&D3&$A $13,Helper&Price.Point,0)),"")

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using a VLOOKUP - when 2 rows match criteria it returns the first value in the cel only how 2 change	djrobst	Excel	4	10-28-2015 01:32 AM
Would like to return a row rather than a cell using VLookup	canajun	Excel	7	12-10-2014 01:03 PM
Vlookup two columns return 3rd	jennamae	Excel	11	01-12-2014 02:53 AM
excel vlookup with multiple criteria	mpokorny	Excel	4	05-06-2012 04:06 AM
Vlookup or Index/Match - Multiple Criteria	ruci1225	Excel	1	01-15-2012 07:31 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:06 PM.