HI Sirs, hope you can help me with my problem..thanksexcel ask.PNGexcel question.xlsx
HI Sirs, hope you can help me with my problem..thanksexcel ask.PNGexcel question.xlsx
In G2 Cell
=INDEX(A:A,MATCH(F2,$C:$C,0))
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
how can i get the card# of roy,ren and ric if the staff ID's are all the same?
hi sir, how can i get the card# of roy,ren and ric if the staff ID's are all the same?
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.
thank you very much sir...ur d best!!!
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks