IF statement uisng index match

  • I need to create a string for excel that will include all the criteria.
    If previous months % premium (sheet 1 column c) is less than this months %premium than apply the % lift (sheet2 D3) to the % of premium (column c) in this month to the number of VDPS (sheet2 column b). If the previous months % premium (sheet 1column c)is greater than this month than back out % lift(sheet2 D3) , if equal than leave the same. All this needs to be matched on owner ID


    I have attached a workbook to helpforum.ozgrid.com/index.php?attachment/69062/

  • Re: IF statement uisng index match


    No Sheet 1 in your sample workbook...

    Where there is a will there are many ways. Finding one that works for you is the challenge!

  • Re: IF statement uisng index match


    Can you show some example outputs and how you achieved them?

    Where there is a will there are many ways. Finding one that works for you is the challenge!

Participate now!

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