Results 1 to 6 of 6

Problem with Index and Match

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    03-23-2008
    Location
    Tennessee
    MS-Off Ver
    Office 2007
    Posts
    706

    Problem with Index and Match

    Morning, Gurus. I've used this formula (garnered from the geniuses on this site) to vlookup data from one sheet to another if 2 criteria were met, and it worked in that instance. Now I am trying to edit the formula to work in a different workbook, with different columns, and seem to be having trouble with the edits.

    I have two worksheets with the same column headings, but the data may be different. I am trying to compare the price in one sheet, (Key), with the price in the sheet where I am entering the formula, (CanKey). I have attached a sample of the workbook, after removing sensitive data. Here is the formula I am entering in column J2 of my CanKey worksheet to return the cost from the Key worksheet (Column I) if the vendor number (Column G) and the product number (Column A) match:

    =INDEX(Key!$I$1:$I$10, MATCH(A2 & G2, INDEX(Key!$A$1:$A$10 & Key!$G$1:$G$10, 0), 0))
    Not sure what I am doing wrong. Any help will be greatly appreciated.

    Have a good one.
    Attached Files Attached Files
    Last edited by [email protected]; 04-25-2015 at 12:13 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Index Match Match - syntax problem
    By Dabooka in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-01-2014, 09:05 AM
  2. [SOLVED] need help...problem index/match
    By Jhon Mustofa in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-19-2013, 03:34 AM
  3. Replies: 6
    Last Post: 05-28-2013, 05:08 PM
  4. index/match problem
    By pma85 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 05-23-2013, 04:37 PM
  5. Problem with INDEX, INDIRECT, MATCH, MATCH
    By JO505 in forum Excel General
    Replies: 5
    Last Post: 09-01-2011, 05:51 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