Results 1 to 3 of 3

In need of a Lookup formula

Threaded View

  1. #1
    Registered User
    Join Date
    11-06-2012
    Location
    Norfolk, VA
    MS-Off Ver
    Excel 2010
    Posts
    9

    In need of a Lookup formula

    I have created a mock version of the problem I'm having. In cell E2 I am trying to make a formula that will lookup the date and item, which will change, and return the value from the rows highlighted in yellow. For example if the date 1/2/2012 were entered in cell B1 and the item entered in cell B2 were 456, then the value returned in cell E2 would be 6. I've tried various combinations of formulas but I cannot seem to lookup the cell below where the column (date) and row (item) intersect. Any help on this would be greatly appreciated.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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