+ Reply to Thread
Results 1 to 4 of 4

Lookup Value and List

  1. #1
    Forum Contributor
    Join Date
    03-07-2009
    Location
    Spain
    MS-Off Ver
    Excel 2003
    Posts
    128

    Lookup Value and List

    Untitled.jpg

    I am looking to do the following.

    1) Look up Sales Japan- then in a cell list the following
    • Executive: 0
    • Manager:0
    • Worker:0

    2) Look up Sales Mexico
    • Executive: 0
    • Manager:2
    • Worker:12

    Ideally the output will be all in one cell

    The three Executive, Manager and Worker may change, so there will always be a list of three following each Business Unit.
    Attached Images Attached Images
    Last edited by leviathan86; 06-24-2013 at 10:27 AM.

  2. #2
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Lookup Value and List

    =sumproduct(($c$6:$c$8=$c6)*($d$3:$f$3=d$3)*(d$5:d$8)) ??
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  3. #3
    Forum Contributor
    Join Date
    03-07-2009
    Location
    Spain
    MS-Off Ver
    Excel 2003
    Posts
    128

    Re: Lookup Value and List

    Brilliant, but how do I add the role as well "Executive" rather than just looking up the number.

  4. #4
    Forum Moderator Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Lookup Value and List

    Not sure that i understand...

    Do you mean?

    =sumproduct(($c$6:$c$8="Executive")*($d$3:$f$3=d$3)*(d$5:d$8)) ??

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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