Results 1 to 3 of 3

Thread: Excel Formula

  1. #1
    3 Star Lounger
    Join Date
    May 2008
    Location
    India
    Posts
    306
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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?
    Attached Files Attached Files
    Regards
    Prasad

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    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 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.


  3. #3
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    123
    Thanks
    0
    Thanked 1 Time in 1 Post
    Or, try…………….

    =LOOKUP(H2,A$2$61)

    Regards
    Bosco

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •