I created a drop down menu on an excel spreadsheet. Everytime I click a different drop down manager name, I want the cells below it (Employees) to automatically change to what ever employee that manager have. I have a table imported from access on sheet (called table).
I want to have some kind of look up that return "the unique employee name" everytime I change the manager drop down name.
For more details please see the attached file.
Thank you very much for your help.
Try this (entered as an Array Formula) using CTRL + SHIFT + ENTER and not just enter
,Formula:
Please Login or Register to view this content.
copied down as far as you need.
Last edited by Glenn Kennedy; 08-13-2014 at 01:20 PM. Reason: Attachment added...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Thanks!!! Your help is greatly appreciated
=IFERROR(INDEX(Table_callsheet[[#Headers],[EMPLID]],SMALL(IF(Table_callsheet[[#Headers],[MGR_EMPLOYEE_NAME]]='DailyR''sByBems'!$G$1,ROW(Table_callsheet[[#Headers],[MGR_EMPLOYEE_NAME]]-5),ROW(1:1)),0),"")
Can you please tell me whats wrong with my formula?
What is header row number in your real table ?
In your example, the Table began (header row) in row 5 of Sheet "Table". If, in your real data, it begins (header row) in row 12 (for example), then substitute the 5 (in big bold red) with 12
Formula:Please Login or Register to view this content.
Also, did you use CTRL + SHIFT + ENTER to set the array formula?
Last edited by Glenn Kennedy; 08-13-2014 at 03:03 PM.
my table began (header row) cell c1 so i replaced it with -1, for some reason it still doesnt work. Yes, I made it the array formula.
thanks for your help
Last edited by nguyenal07; 08-13-2014 at 04:10 PM.
Hi attached a very similar version of the excel please help me on getting the formula to get the list of employees id for each manager using the drop down list..
Thanks,
Re: Look up function
Try this in A7 and drag it down..
Formula:Please Login or Register to view this content.
if you want to know how it works.. then click following links...
http://www.excelforum.com/tips-and-t...-countifs.html
or
http://excel-buzz.blogspot.in/2014/0...xsmall-as.html
Don't forget to click *
I don't know what was going on, but it's fine, now.
I was looking at the formula that you posted (#4). You seem to have made an error in selecting the data column. This bit [#Headers] shouldn't be there.
It still doesnt workI attached another file that is exactly the same from what I have
Please help thanks
Can you post YOUR attempt at getting it to work, so that I can see what you are doing wrong?
In the meantime, here's your own sheet, working again. It would be good to see wjht you have tried & failed with. that way, you'll know what to do next time...
Just a random thought.... Are you physically typing the curly braces round the formula? Hoipefully the answer is "no". Excel will enter them when you set the formula with CTRL + SHIFT + ENTER
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks