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 helpozgrid.com/forum/core/index.php?attachment/69062/

    Files

    • Example.zip

      (1.18 MB, downloaded 75 times, last: )
  • 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!


    MS Excel MVP 2010-2016

  • 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!


    MS Excel MVP 2010-2016