Results 1 to 6 of 6

Value updating based on variable dates

Threaded View

  1. #1
    Forum Contributor
    Join Date
    07-05-2012
    Location
    Stockholm
    MS-Off Ver
    Excel 2010
    Posts
    162

    Value updating based on variable dates

    Hi guys,
    I'm trying to set a formula to pull values based on if they match a certain date (month). So there needs to be some sort of lookup or IF function I think, but I can't get my head around it.

    In the attached sheet cell C1:E1 are variable dates. Cells C2:E5 should pull values from the table below depending on if the dates in C1:E1 match.

    Any ideas?
    Attached Files Attached Files

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