Jan 05 2021 05:23 AM
I need to find out how do I set up in Excel:
select name "Roman" - it put to second cell "Manager"
select name "Andreas" or "Claus" - it put to second cell "Production Manager"
Jan 05 2021 05:26 AM
It looks like you need dependent drop-down list, sample is here Dependent Drop-down Lists in Excel - Easy Excel Tutorial (excel-easy.com) or you may google for much more posts.
Jan 05 2021 06:10 AM
In Reply check "browse" or just drag the file. If you have older interface it shall be small "attachment" icon somewhere here.
Jan 07 2021 12:05 AM
Thank you for the file. I'd add the table somewhere in workbook which maps names and positions
better in separate sheet and you may hide it after the workbook is ready.
For the names we create drop-down list in data validation using first column of the name. Position will be picked-up by formula like
=INDEX(tblPositions[Position], MATCH($D$4,tblPositions[Name],0))
or you may use VLOOKUP() or XLOOKUP() or simple LOOKUP() if you are more familiar with them.
Jan 07 2021 12:39 AM
@Sergei Baklan I guess I'm stupid, I can't do it. Could you do this to me in this file, please? The first sheet - there it has to be (cell D61 and D63), the last sheet, there are given those names and positions - column Q and R.
THANKS A LOOOOOOT :)
Jan 07 2021 01:53 AM
To be more flexible we use dynamic range for data validation list with names as
=OFFSET(zoznamy!$R$2,,,COUNTA(zoznamy!$R:$R)-1)
When position will be returned as
=INDEX(zoznamy!$S:$S,MATCH($D$61,zoznamy!$R:$R,0))
Jan 07 2021 03:37 AM
@Sergei Baklan Hello Mr. Baklan, could me tell me how I can change "Vedúci" to "Vedúci výroby pre oblasť zvárania podvozkov"?
Thanks a lot
Jan 07 2021 03:47 AM
That's since D61 was formatted with Wrap Text. With that to scroll it or expand the size of the row. Or remove Wrap Text - that will be as in attached.
Jan 07 2021 03:55 AM
@Sergei Baklan Fantaaastic :-).. The last thing, I swear, Claus Steiner has to have also "Vedúci výroby pre oblasť zvárania podvozkov".
Thanks a lot :)
Jan 07 2021 04:00 AM
@EvaSopuchova82 , you are welcome, added.
If other names/positions keep adding the in columns R and S