+ Reply to Thread
Results 1 to 3 of 3

Multiple lookup value but not returning table array results

  1. 04-14-2014, 01:15 PM #1
    swannee
    swannee is offline
    Registered User
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Multiple lookup value but not returning table array results

    I'm new to posting in any forum, so I'm not really sure about the etiquette. My apologies if I'm not posting correctly. Not sure which formula to use. Need to return values from 6 colums for 2 lookup values.

    (Cust No + Item No) needs to return usage for prior 6 weeks for same (cust no + item no)
    information is on two different tabs.

    Please help

    adding sample workbook

    excel forum request.xlsx
    Last edited by swannee; 04-14-2014 at 01:59 PM. Reason: add sample workbook
    Reply With QuoteRegister To Reply
  2. 04-14-2014, 01:31 PM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,728

    Re: Multiple lookup value but not returning table array results

    It would help if you posted a sample workbook - the FAQ describes how to.

    Pete
    Reply With QuoteRegister To Reply
  3. 04-14-2014, 02:12 PM #3
    swannee
    swannee is offline
    Registered User
    Join Date
    04-14-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Multiple lookup value but not returning table array results

    I posted the sample workbook in the original post
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Lookup on 1 criteria but returning multiple results
    By swingding in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-08-2013, 05:18 AM
  2. [SOLVED] Lookup to return multiple results - without array
    By ZeDoctor in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-22-2012, 07:42 AM
  3. [SOLVED] Returning an array of lookup values from an input array, rather than single value
    By jase250 in forum Excel General
    Replies: 19
    Last Post: 05-09-2012, 03:31 AM
  4. Returning multiple results for one lookup value
    By Lizzietish11 in forum Excel General
    Replies: 5
    Last Post: 01-29-2009, 03:09 PM
  5. Lookup Returning Multiple Results
    By joe1182 in forum Excel General
    Replies: 4
    Last Post: 02-01-2006, 08: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1