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

ArviLaanemets · #6 01-22-2018, 09:03 AM

Quote:

Originally Posted by EcommDOC

Arvi I don't need sums of anything, I need to create 2 separate Pick list for 1 store from 1 huge pick list of multiple stores and 2 price points

When you calculate a sum which returns a numeric value from certain row, it works effectively as lookup. The idea is to compose conditions for sumifs() in a way, that a single numeric value is returned. I myself use this technique often, as it allows to apply unlimited number of conditions.

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