Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Retrieve data with MAX and VLOOKUP
I have a data table I'm trying to retrieve data from(to another worksheet)
that gives me the highest number in a list for a specific ID and only if the #days is between 15 and 30. For example: Data table: A B C ID Type #days 80 MD 15 62 MD 22 28 MD 10 80 MD 28 62 MD 1 Would like to lookup the ID and give me the highest # days in the list for those with #days between 15 and 30. So results for this would be: ID Type #days 80 MD 28 62 MD 22 Can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Retrieve VLOOKUP results based upon a conditional statement | Excel Discussion (Misc queries) | |||
Vlookup to retrieve a hyperlink | Excel Discussion (Misc queries) | |||
Can vlookup be used to retrieve multiple matches | Excel Discussion (Misc queries) | |||
Retrieve multiple data rows data from a very long list and copy t | Excel Discussion (Misc queries) | |||
vlookup doesn't retrieve subscript formatting Why? | Excel Discussion (Misc queries) |