Microsoft Office Forums - View Single Post - How can I return Vlookup only if Specific Criteria is met in 1 column of the Vlookup Array

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

View Single Post

Old

01-20-2018, 11:36 PM

xor

xor is offline

xor uses Windows 10

Windows 10 xor uses Office 2016

xor uses Office 2016

Office 2016

Expert

Join Date: Oct 2015

Posts: 1,101

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

xor is a name known to all

Default

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)),"")

Reply With Quote