+ Reply to Thread
Results 1 to 3 of 3

LOOKUP function in creation of filtering list of employees

  1. #1
    Registered User
    Join Date
    06-19-2012
    Location
    Taipei, Taiwan
    MS-Off Ver
    Excel 2010
    Posts
    16

    LOOKUP function in creation of filtering list of employees

    I have some problem with LOOKUP function, when I type:
    =LOOKUP("Ω",{"";"ok"}), the result is "ok",
    =LOOKUP("1",{"";3}) or =LOOKUP("1",{"";"3"}), the result is "" (blank).
    In other cases, I write following formulars:
    =LOOKUP("Ω",{"fail";"ok"})
    =LOOKUP(1,{"";"ok"})
    =LOOKUP(1,{"";3})
    =LOOKUP(1,{2;3})
    =LOOKUP("1",{2;3})
    They always return the same result "#N/A".

    Please, instruct me the performance method of LOOKUP function in aforesaid formulars.
    For more details, I wrote in attached file, thank you for anyway!
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,059

    Re: LOOKUP function in creation of filtering list of employees

    Im not sure what you are trying to achieve with that formula, but if you want to extract unique employee numbers and then calc their totals, use these, copied down...

    =IFERROR(INDEX($B$3:$B$27,MATCH(0,INDEX(COUNTIF($F2:F$2,$B$3:$B$27),0,0),0)),"")

    and then
    =IF(E3="","",SUMIF($B$3:$B$27,E3,$C$3:$C$27))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    06-19-2012
    Location
    Taipei, Taiwan
    MS-Off Ver
    Excel 2010
    Posts
    16

    Re: LOOKUP function in creation of filtering list of employees

    Thank you for your nice function, it works every good.
    I'm trying to learn LOOKUP function to apply in other circumstances, I'm quite confused in this function, exactly, I don't comprehend it well, I really need more explaination and example from you.
    Last edited by megaiooo; 08-09-2013 at 12:59 AM.

+ 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. Formula Creation: Using List Function + Subtraction Function
    By HelpMe! in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-09-2013, 04:52 PM
  2. [SOLVED] Help with list filtering function
    By imperitor in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-26-2012, 02:20 PM
  3. lookup a company and validate the employees
    By dwetzel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-13-2012, 05:28 PM
  4. Excel Lookup Function + Filtering/Displaying Data
    By jmadore in forum Excel General
    Replies: 3
    Last Post: 11-15-2011, 10:08 AM
  5. Scheduling employees by dates... LOOKUP or FILTER?
    By ssleene in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-14-2005, 03:00 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1