checkbox

Copper Contributor

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"

16 Replies

@EvaSopuchova82 

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.

Thanks a lot. It is what I need :)
It is not worked :(

@EvaSopuchova82 

Could you please provide small sample file?

Off course. How can I put here attachment?

@EvaSopuchova82 

In Reply check "browse" or just drag the file. If you have older interface it shall be small "attachment" icon somewhere here.

image.png

 

@EvaSopuchova82 

Thank you for the file. I'd add the table somewhere in workbook which maps names and positions

image.png

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.

 

@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 :)

@EvaSopuchova82 

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))

@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

@EvaSopuchova82 

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.

@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 :)

 

@EvaSopuchova82 , you are welcome, added.

If other names/positions keep adding the in columns R and S

image.png

@Sergei BaklanYou are fantaaaaastic! :)

 THANKS A LOT! :)

@EvaSopuchova82 , glad to help, good luck