+ Reply to Thread
Results 1 to 2 of 2

How to display a "text value" after matching a "date" in a certain "date range"

  1. #1
    Registered User
    Join Date
    09-15-2010
    Location
    New York
    MS-Off Ver
    Excel 2010
    Posts
    1

    How to display a "text value" after matching a "date" in a certain "date range"

    Hi guys i need some help on this workbook that I'm doing (please see attached file)


    1. I basically need to show what is on the "Name" row (O31) on the "Subcontractor" (D22).

    2. The idea is whenever I will change the "Date" it will show the corresponding value on "Subcontractor".
    Ex. on 8/19/10 the Subcontractor is "text1"
    on 8/20/10 the Subcontractor is "text2"
    so if I change the "Date" to 8/19/10 it should show "text1" and if I change it to
    8/20/10 it should show "text2"

    3. I have no problem showing numbers but I don't know the way to show it as a text.


    Please help I will really appreciate it. thanks.

    Mike
    Attached Files Attached Files
    Last edited by deverom; 09-15-2010 at 12:56 AM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: How to display a "text value" after matching a "date" in a certain "date range"

    I think you may be after

    =INDEX(P31:IV31,MATCH(I4,P30:IV30,0))

    in D22

    cheers

+ 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