Results 1 to 5 of 5

Help Creating A Formula That Matches Values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Question Help Creating A Formula That Matches Values

    Hello,
    I need and formula that matches and values between a set of values in one row with values in another.

    Criteria
    >In column "AJ": I want the value from “AI” to be match with value between “I2:AH2” but only match with the heading of “MP” with the result being the number that is in the same row as the formula.

    >In column "AK": I want the value from “AI” to be match with value between “I2:AH2” but only match with the heading of “P” with the result being the number that is in the same row as the formula.


    Please see the attached spreadsheet self-calculated examples what I am trying to accomplish. Everything in the attached spreadsheet is calculated and entered by hand so it may contain errors. Thank you for any help you can provide it. Please feel free to ask any questions.
    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. [SOLVED] Formula to search for matches, duplicates and new values between 2 columns
    By randomkiwi in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-19-2016, 04:53 PM
  2. Replies: 1
    Last Post: 09-26-2013, 12:16 PM
  3. [SOLVED] Creating an IF formula with SUM using set values and variable values
    By rjordine in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-26-2013, 01:05 AM
  4. [SOLVED] INDEX MATCH array formula that matches substring n gives multiple matches
    By bkwins in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-12-2013, 04:57 AM
  5. Replies: 10
    Last Post: 10-23-2012, 12:56 PM
  6. creating a finder that returns matches
    By msundst in forum Excel General
    Replies: 1
    Last Post: 11-15-2010, 11:55 AM
  7. Creating Alerts for Non-matches
    By wolfreton1989 in forum Excel General
    Replies: 5
    Last Post: 08-05-2009, 12:08 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