Max Value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a sent worksheets that supply data. HOwever I would like to set up a VLookup that looks by Month and Max Value. For Example Column A is Jan, Feb, March, Feb, Jan, Mar and Column B is 42, 18, 22, 38, 45, 11. I want to look for particular month and highest value in that month
 
How about this:

=MAX(IF(A1:A30="Jan",B1:B30))

This is an array formula. 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.)

(and adjust the ranges accordingly)
 
Back
Top