+ Reply to Thread
Results 1 to 2 of 2

Showing dates in seperate sheet from selection in list box

  1. #1
    Forum Contributor
    Join Date
    07-30-2012
    Location
    Leeds
    MS-Off Ver
    Excel 2013
    Posts
    177

    Showing dates in seperate sheet from selection in list box

    Hello,
    I have a list box which takes its values from =$O$2:$U$2

    G8:G37 then find a value in another sheet based on the selection in the list box with the following code (for G8):
    =IF(OFFSET(Summary!$H4,0,MATCH($J$2,Summary!$I$3:$O$3,0))<Master!$C4,Summary!$A4,"")

    Dates
    The dates are stored in the BoundariesTerms
    BoundariesTerms!$J$1:$P$3
    In row 1 is the term headers (Term 1 (column J) to Term 7 (column P))
    In row 2 is the term start date
    In row 3 is the term end date

    In cell J4, I would like to show the start date of the term selected by the list box in J2
    In cell J6 I would like to show the end date of the term selected by the list box in J2

    Many thanks all

    Luke

  2. #2
    Forum Contributor
    Join Date
    07-05-2012
    Location
    Houston, Texas
    MS-Off Ver
    Excel 2016
    Posts
    165

    Re: Showing dates in seperate sheet from selection in list box

    Could you upload a sample?
    Click on the * icon if this post has been helpful.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1