+ Reply to Thread
Results 1 to 11 of 11

Lookup a Value and Return Multiple Results

Hybrid View

  1. #1
    Registered User
    Join Date
    03-05-2014
    Location
    Australia
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: Lookup a Value and Return Multiple Results

    As you can see the duty number in the sick leave column are in order from the spreadsheet. So if a duty calls in sick from above (earlier start time, as it is sorted by that), the duty on the right hand side is placed above the previously placed duty.
    I don't know if I am explaining it right. But if you type "s/l" in the "code" section and above the ones that are already marked, u'll see that the duty you type in will be placed above that in tje right hand side " sick leave section".

    Maybe there is a code I can put in to check the "j" column and if it has any value in it then wont change vale if an earlier duty calls in sick.

    thank you for your help.

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Lookup a Value and Return Multiple Results

    Sorry, still confused!

    In the sample file...

    I entered S/L in cell C22 (Duty 308).

    Now we have:

    Data Range
    I
    J
    K
    26
    308
    ------
    8:10
    27
    342
    9:10
    28
    113
    9:25


    What do you want it to display?
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

+ 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. Lookup a Value and Return Multiple Results
    By tigeravatar in forum Tips and Tutorials
    Replies: 13
    Last Post: 04-08-2016, 04:44 PM
  2. [SOLVED] Name Variable LOOKUP to return multiple results
    By mmayna03 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-03-2012, 01:59 PM
  3. Lookup & return Multiple Results
    By benishiryo in forum Excel Tips
    Replies: 2
    Last Post: 07-11-2012, 10:11 AM
  4. lookup 2 values and return multiple results
    By humboldtguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2010, 09:49 PM
  5. Return Multiple Results with Lookup
    By Josh O. in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-04-2005, 05:06 PM

Tags for this Thread

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