RETURNING A SPECIFIC VALUE FROM A LOOKUP FORMULA

[Guest]

I understand how to use the vlookup/hlookup function in Excel, however the
problem that I am encountering is that when I do a vlookup it returns the
result for the first occurence of the value being looked up. Is there
another formula that will return all of the results for that lookup value, or
at least one that will return a specific result like the max/min for a given
value.

Thanks!
Drew

 

[Dave Peterson]

There are other functions that may work the way you want:

=sumif(C1:C10,"a",D110)

=max(if(c1:c10="a",d1:d10))
=min(if(c1:c10="a",d1:d10))

The last two are array formulas. Hit ctrl-shift-enter instead of enter. If you
do it correctly, excel will wrap curly brackets {} around your formula. (don't
type them yourself.)

Adjust the range to match--but you can't use the whole column.