+ Reply to Thread
Results 1 to 4 of 4

I need Horizontal look up that looks at a Part Number and date

  1. #1
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    2010
    Posts
    337

    I need Horizontal look up that looks at a Part Number and date

    Hello All

    Please see attached

    I9 = Needs to look at part number in C9 and search Product list and return week 16 data
    As it stands its being done like this = ('Product List'!H49) which is taking an awful long time when something changes

    Expected results are in yellow


    Cheers for looking
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-15-2020
    Location
    malaysia
    MS-Off Ver
    office2007
    Posts
    345

    Re: I need Horizontal look up that looks at a Part Number and date

    worksheet name : 80t PRESS GROUP ,I9 cell formula , copy and drag right
    HTML Code: 
    =IFERROR(VLOOKUP($C9,'Product List'!$B$4:$Y$500,MATCH(I$6,'Product List'!$H$4:$Y$4,)+6,),"")
    Last edited by wk9128; 09-30-2020 at 06:14 AM.

  3. #3
    Forum Contributor
    Join Date
    04-06-2017
    Location
    Wolverhampton
    MS-Off Ver
    2010
    Posts
    337

    Re: I need Horizontal look up that looks at a Part Number and date

    Thank you, Works well

  4. #4
    Forum Expert Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    4,242

    Re: I need Horizontal look up that looks at a Part Number and date

    Or try at I9
    =IF($C9="","",INDEX('Product List'!H$8:H$68,MATCH($C9,'Product List'!$B$8:$B$68,)))
    Attached Files Attached Files

+ 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. [SOLVED] Part Number and Date Look up return
    By pmw19800 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-17-2020, 10:35 AM
  2. Max date for each part number grouping for pivot table
    By BobZZ in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-30-2017, 02:44 AM
  3. [SOLVED] Count number of values dependent between horizontal date range based on 2 date values
    By dcad81 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-06-2015, 08:16 AM
  4. Help returning part number 1 time and adding up like part number QTY
    By SOLERSA in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-16-2014, 06:31 AM
  5. [SOLVED] Pull earlest expiration date per part number.
    By mithandir1 in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 11-17-2013, 02:50 PM
  6. Replies: 2
    Last Post: 03-01-2012, 06:17 AM
  7. Sumif for part number across date range.
    By chaysp81 in forum Excel General
    Replies: 3
    Last Post: 01-21-2011, 05:02 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