if I put name and team then how can I put Employee code and Designation.
File is attached for reference.
if I put name and team then how can I put Employee code and Designation.
File is attached for reference.
Click on (*), if you agree.
Put this in C3 and copy across...
=INDEX(C6:C16,MATCH(A3&"-"&B3,INDEX(A6:A16&"-"&B6:B16,0),0))
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
see the attachments
i hope you may like it
you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below my 1st post to you)
Thanks for the feedback![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks