Results 1 to 10 of 10

Creating a three way lookup with columns and row lookup matches

Threaded View

  1. #1
    Registered User
    Join Date
    07-14-2014
    Location
    Canada
    MS-Off Ver
    2010
    Posts
    9

    Creating a three way lookup with columns and row lookup matches

    Hello,

    I'm trying to create a lookup/match function that displays a value if certain criteria are met/matched.
    Capture.JPG

    What I want is to be able to enter a formula under Price (D) that will match the Hour (C) and Date (B) and Name (A) to the index table from (F) to (K) and pull in the value for that Day/Hour/Name.
    For example, the formula in (D,2) would pull in the Price of 8 for December 17, 2014, Hour 1 and the A name.

    Is this possible?

    Thanks for the help!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 04-08-2014, 03:11 AM
  2. [SOLVED] Multiple lookup adding columns, then multiplying, then lookup, add, and subtract
    By mamig in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-08-2013, 12:55 AM
  3. Replies: 7
    Last Post: 06-19-2011, 12:51 PM
  4. Lookup several possible matches
    By Jasonr in forum Excel General
    Replies: 2
    Last Post: 12-06-2010, 09:56 AM
  5. Lookup adjacent column to multiple lookup columns.
    By JAMES4228 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-13-2009, 03:19 PM

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