+ Reply to Thread
Results 1 to 4 of 4

Formula to lookup data contained in a matrix

  1. #1
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2021 H: 365
    Posts
    940

    Formula to lookup data contained in a matrix

    Evening all,

    I have a matrix and I need to return the relevant rate based on various criteria selected. Two of the criteria are held vertically in rows and one horizontally across columns.

    I've attached an example of the data I'm working with. The green cells are for the criteria selections and the red for the formula.

    If you have any queries just give me a shout.

    Thanks in advance,

    Snook

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Formula to lookup data contained in a matrix

    Please try this formula.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  3. #3
    Valued Forum Contributor
    Join Date
    09-09-2009
    Location
    Liverpool, England
    MS-Off Ver
    W: 2021 H: 365
    Posts
    940

    Re: Formula to lookup data contained in a matrix

    Bob on! Cheers FlameRetired, much appreciated!

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Formula to lookup data contained in a matrix

    Glad to help. Thank you for the feedback and added rep.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Matrix Lookup formula
    By sweetlou26 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-22-2016, 02:00 AM
  2. V lookup and match in a matrix - formula please
    By Tomaroda in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-21-2016, 10:17 AM
  3. [SOLVED] Formula - matrix lookup
    By kwagam in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-11-2014, 07:35 AM
  4. Search lookup array to find lookup value contained within text string
    By Cookstein2 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-02-2011, 09:42 AM
  5. Lookup unsorted data contained in a prior column
    By steinfm in forum Excel General
    Replies: 1
    Last Post: 07-12-2011, 06:28 PM
  6. 3 tiered matrix lookup formula
    By atlas_85 in forum Excel General
    Replies: 2
    Last Post: 01-14-2011, 11:37 AM
  7. Using data contained in a matrix table on another sheet
    By redimp in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-18-2010, 01:50 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