# get the card# from staff ID as lookup value

1. ## 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. ## 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. ## 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. ## 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. ## 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. ## Re: get the card# from staff ID as lookup value

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

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

Glad it helps you and thanks for the feedback and rep

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

#### 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