Dear All,
Hi how are you? I hope everything is good with you.
I want to ask something to you, if there is two drop down list of department and employee name that can be chosen, what function on excel should i use on employee number, so employee number with according employee name and department list can appear.
Thanks for your help.
Regards,
Devi S
Please try this file.
Last edited by ramananhrm; 09-18-2013 at 01:10 AM.
Please click 'Add reputation', if my answer helped you.
you can use this ARRAY formula...
=INDEX($C$3:$C$7,MATCH($B$11&$B$12,$A$3:$A$7&$B$3:$B$7,0))
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks