Results 1 to 5 of 5

One to Many lookup

Threaded View

lemonap618 One to Many lookup 01-28-2019, 02:02 AM
AliGW Re: One to Many lookup 01-28-2019, 02:05 AM
AliGW Re: One to Many lookup 01-28-2019, 02:27 AM
kvsrinivasamurthy Re: One to Many lookup 01-28-2019, 04:40 AM
Glenn Kennedy Re: One to Many lookup 01-28-2019, 05:24 AM
  1. 01-28-2019, 02:02 AM #1
    lemonap618 is offline
    Forum Contributor
    Join Date
    02-06-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    112

    One to Many lookup

    Hello,
    And thank you for all the help!
    Quick question - on the attached I have a sales manager tab. I would like to bring in the customer and revenue data for each sales rep. this is located on the "Map" tab. What is the best way to dynamically bring in the customer and revenue data. Looking for a formula.
    For example - Huleniova, Zuzana has 16 customers ( I would like each customer listed in the sales manager tab with the corresponding revenue). Thanks!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Lookup: Lookup employee id and return value in cell x basued on most recent start date
    By jekeith in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-21-2018, 12:56 PM
  2. Two Lookup and Return (Lookup the column, then lookup the row)
    By Branbran10 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 08-05-2015, 04:55 PM
  3. Index lookup with 2 lookup values and then return multiple results - array formula
    By D.Lovell in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-19-2015, 08:42 PM
  4. [SOLVED] Multiple Lookup Values rows and columns to lookup a single target column on the right end.
    By gurusanthanam in forum Excel General
    Replies: 3
    Last Post: 04-08-2014, 03:11 AM
  5. LOOKUP - I need to lookup a value where the lookup vector is in any order
    By LukeMC in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-19-2013, 08:46 AM
  6. using lookup to return a value, else leave blank. 2 sheets - vendor sht 2nd lookup sheet
    By rosemwd in forum Excel General
    Replies: 1
    Last Post: 11-07-2012, 01:57 PM
  7. VBA: Index/Match. 1 lookup value, 1 lookup array. copies cells from multple columns.
    By rain4u in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-19-2011, 12: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1