+ Reply to Thread
Results 1 to 1 of 1

Finding a column value based on date and column header

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Finding a column value based on date and column header

    I need a formula that will return the value in a cell value for a certain date. For example,

    On Sheet 2 columns headers are week ending values, Column B is 8-Jan-12, Column C is 16-Jan-12, etc.
    Column A are names of products.

    On Sheet 1, I want to populate a corresponding cell in Sheet 1 for the product based on the date entered by the user on Sheet 1.

    Attached is an example

    Based on the date entered in B1 on Master-Weekly sheet, I want to populate cells in column D (Item Weekly Ending Usage) with the value from Weekly_new Sheet for the respective Brand.

    if(date in B1 is same as date in sheet Weekly_new for Brand in Master-Weekly_A5) populate Master-Weekly_D(Brand) with that value.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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