i am in need of a formula for finding out the max that meets a criteria.
i've attached the spreadsheet, for an example. what i'm looking to do is have the highlighted cell as an input. based on that input, i'd like to find out the highest number than is associated with that number (sounds confusing to say it this way... but, i need the maximum number that is less than or equal to the input number). from there, i can figure out how and what to use for the vlookup and/or index, match part of things.
i looked a little at DMAX, which seems like it might work, but, can't get it to do what i want.
[in the excel attachment, i filled in the values that i want it to say, after the formula is inserted into the cell. in particular, cell A4 is the real concern. i can figure the rest out.]
thank you, in advance, for any assistance
Bookmarks