Max Value

[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

 

[Dave Peterson]

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)