Vlookup max number

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

    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

    Re: Vlookup max number


    Brilliant!!!Many thanks fior your help

    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!

Register Yourself Login