Vlookup max number

  • I am hoping someone can suggest a code for the attached. I need something like a Vlookup in sheet1 that will find the maximum number for each month when looking at sheet2. I.e Shhet1 Jan 11 would show Apples 436, Oranges 843 etc, etc.Thanks

  • Re: Vlookup max number


    Thanks, but this is only giving me numbers in rows 3 and 18 on sheet1 - and these aren't the correct figures. All other cells are showing '0'

    I've found that the problem usually lies inbetween the keyboard and the chair

  • Re: Vlookup max number


    Used Ctrl-Shift-Enter and it works for the first year, then starts to repeat the '11 figures if I stretch to '12 year. I have amended the formula to cover the increase in rows to account, but still only repeatsThanks

    I've found that the problem usually lies inbetween the keyboard and the chair

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!