+ Reply to Thread
Results 1 to 7 of 7

get the card# from staff ID as lookup value

  1. #1
    Registered User
    Join Date
    01-09-2013
    Location
    DUBAI, UAE
    MS-Off Ver
    Excel 2010
    Posts
    10

    get the card# from staff ID as lookup value

    HI Sirs, hope you can help me with my problem..thanksexcel ask.PNGexcel question.xlsx

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: get the card# from staff ID as lookup value

    In G2 Cell

    =INDEX(A:A,MATCH(F2,$C:$C,0))

    Drag it down...

  3. #3
    Registered User
    Join Date
    01-09-2013
    Location
    DUBAI, UAE
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: get the card# from staff ID as lookup value

    how can i get the card# of roy,ren and ric if the staff ID's are all the same?

  4. #4
    Registered User
    Join Date
    01-09-2013
    Location
    DUBAI, UAE
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: get the card# from staff ID as lookup value

    hi sir, how can i get the card# of roy,ren and ric if the staff ID's are all the same?

  5. #5
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: get the card# from staff ID as lookup value

    In G2 Cell - Array Formula - Requires CTRL+SHIFT+ENTER

    =IFERROR(INDEX($A$2:$A$6,SMALL(IF($C$2:$C$6=$F2,ROW($C$2:$C$6)-MIN(ROW($C$2:$C$6))+1),COUNTIF($F$2:F2,F2))),"")

    Drag it down…

    Array formulas need to be entered using the key combination of CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT key then hit ENTER.

  6. #6
    Registered User
    Join Date
    01-09-2013
    Location
    DUBAI, UAE
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: get the card# from staff ID as lookup value

    thank you very much sir...ur d best!!!

  7. #7
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: get the card# from staff ID as lookup value

    Glad it helps you and thanks for the feedback and rep

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ 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. Staff Planner - How To Set Up UserForm to Generate Data into Staff & Date Spreadsheet
    By Marie Snell in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-19-2013, 11:04 PM
  2. [SOLVED] Credit card type based on card number
    By wlsnoops in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-26-2013, 10:25 AM
  3. wild card in macro for worksheet lookup
    By jw01 in forum Excel General
    Replies: 1
    Last Post: 06-22-2012, 10:45 AM
  4. V Lookup Function to make a Score Card
    By mrjoka in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2007, 07:56 PM
  5. [SOLVED] Lookup:Staff,Contract
    By nussbaum in forum Excel General
    Replies: 1
    Last Post: 02-24-2005, 08:06 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