Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
RETURNING A SPECIFIC VALUE FROM A LOOKUP FORMULA
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
RETURNING A SPECIFIC VALUE FROM A LOOKUP FORMULA
There are other functions that may work the way you want:
=sumif(C1:C10,"a",D1:D10) =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. Drew wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning a cell's formula in a different cell | Excel Worksheet Functions | |||
Formula returning #N/A Error---why??? | Excel Worksheet Functions | |||
Lookup Formula - but have a formula if it can't find/match a value | Excel Worksheet Functions | |||
Lookup Function - Specific Values | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) |