• Excel Formula

    Author
    Topic
    #463916

    Hi all,

    In attached wb, I am trying to insert period code (Col. D) in Col. I, If purchase date (Col. H) is fall within a particular period (between start date & end date). What formula should I use?

    Viewing 1 reply thread
    Author
    Replies
    • #1185706

      In I2, enter the formula =VLOOKUP(H2,$A$2:$D$61,4) and fill down as far as needed.
      This assumes that the table in columns A:D will always be sorted on the start date (column A) and that there are no gaps in the time periods. Column B is not needed for the formula.

    • #1185709

      Or, try…………….

      =LOOKUP(H2,A$2:D$61)

      Regards
      Bosco

    Viewing 1 reply thread
    Reply To: Excel Formula

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: