+ Reply to Thread
Results 1 to 5 of 5

INDEX and MATCH - Pull Unit Price for an Item

  1. #1
    Registered User
    Join Date
    04-05-2021
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    3

    Lightbulb INDEX and MATCH - Pull Unit Price for an Item

    Good Day Everyone,

    I was hoping you can help me with my problem. I can't somehow pull the Unit Price of an item using the data provided on a different table.

    On the attached, my formula goes as follows:

    =INDEX(TABLE5[Net price],MATCH([Item Code],TABLE5[Material],0))

    Your help is very much appreciated.
    Attached Files Attached Files
    Last edited by harveyg; 04-05-2021 at 02:13 PM.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: INDEX and MATCH - Pull Unit Price for an Item

    Item Code is TEXT while Material is NUMBER

    =INDEX(TABLE5[Net price],MATCH([Item Code]+0,TABLE5[Material],0))

  3. #3
    Registered User
    Join Date
    04-05-2021
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    3

    Re: INDEX and MATCH - Pull Unit Price for an Item

    The formula worked now!

    Just a question though (For me to understand the process better): why was +0 added on the formula?

  4. #4
    Registered User
    Join Date
    04-05-2021
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    3

    Re: INDEX and MATCH - Pull Unit Price for an Item

    The formula worked now!

    Just a question though (For me to understand the process better): why was +0 added on the formula?

  5. #5
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: INDEX and MATCH - Pull Unit Price for an Item

    +0 converts the text value (Item Code) to numeric so the MATCH will now work

+ 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. Replies: 2
    Last Post: 11-17-2018, 03:15 AM
  2. How to Match Item Price with Item Automatically
    By sunilvdkn in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-24-2018, 05:03 AM
  3. Replies: 2
    Last Post: 01-14-2014, 08:31 PM
  4. Replies: 3
    Last Post: 01-03-2013, 12:32 AM
  5. Replies: 3
    Last Post: 12-27-2012, 01:20 PM
  6. Replies: 4
    Last Post: 08-15-2012, 09:49 AM
  7. Replies: 3
    Last Post: 12-12-2011, 01:11 PM

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