Results 1 to 8 of 8

Using Index(Match) to populate list

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-27-2013
    Location
    Nebraska
    MS-Off Ver
    Office 365
    Posts
    115

    Using Index(Match) to populate list

    Hello,

    I have workbook with two different tabs for material. On the Matl tab the user would enter the material's part number that they are wanting to use. This value in column A is then used elsewhere. I have added a second tab, Matl2, that I am wanting to automatically populate values in column A if they are entered on the Matl tab. I was able to get this to work using an index match for some of the material numbers. The ones I am having trouble with are the materials in column B with a "-##" behind them. For instance, on row 18 I have a 702032 in column A of the Matl tab. I am wanting that same 702032 to be populated on the Matl2 tab. I have attached the sheet I am working with to help. There are usually twice as many materials on the Matl tab because we have different pricing for different locations.

    Thank you
    Attached Files Attached Files
    Last edited by erice; 05-10-2018 at 04:14 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. INDEX MATCH MATCH will not auto populate and takes LONG
    By njm0059 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2018, 04:32 AM
  2. How do I populate an Order Sheet from a Product List using INDEX MATCH?
    By HWall97 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-10-2017, 09:47 PM
  3. Replies: 5
    Last Post: 02-18-2017, 11:21 AM
  4. [SOLVED] Using Match, Index and concatate to populate a fixture table.
    By foozbear in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-02-2015, 02:54 AM
  5. [SOLVED] Index Match/Populate data based on key value
    By mzafar in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-03-2013, 01:49 PM
  6. Index, Match and populate data
    By danmar7 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2010, 03:19 PM
  7. Populate listbox using vlookup or index,match?
    By sarahng86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2007, 08:42 AM

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