Dropdown that says one name but once selected inputs another

[APP123]

Hello everyone,

please refer to the workbook attached

I am looking for a way to have a drop down menu placed in G6 G7 G8 and so on that has a list of names that are located in the 'info' tab in the work book.
however I am wondering if it is possible for when you select a name e.g. Accounts payable to input 'AP' into the cell and Admin as 'AD'

the workbook is going to be used to pretty much track what we do everyday and how much time we spend doing certain tasks hence the names.
I will be placing these results in a table on the sheet called analysis and that is why they prefer the abbreviations as there are quite a few and the table would look huge if it had the full names.

if anyone one has any suggestions I would be really appreciative thanks

[APP123]

bump hopefully someone knows

[FDibbins]

Where is the Drop-Down? I looked in G6:G8 on all sheets anc cannot find it?

[APP123]

sorry my English must not have been super clear, there is currently no drop down there I am wanting to enquire if it is possible to place one in G6 and onwards, the list of words and their abbreviations are in the 'info' sheet at the end of the workbook

[FDibbins]

OK so do you want to have G6 etc display AP or display Accounts Payable? If you leave it as Accounts Payable, we can use that to pull the info you want (although if it says AP, we could use that as well)

Perhaps if you filled in some (dummy) data, it would help to show what your end product will look like?

[APP123]

I am wanting to have a drop down that says the word accounts payable but once selected from the list I want it to populate the abbreviation for it which is AP. I currently don't know how to do that so I don't know how to do a dummy sorry, but all the names that will be used and their abbreviations are in the info sheet at the end.

[FDibbins]

OK take a look at the attached. I dont know of any way to have a DD list 1 set of items (the full word), but return something else (the abbreviation) when selected - at least, not with a regular formula, so what I did was added a helper column (H) for the DD and formatted the text white so it looks invisible. then in G, i use an index/match to pull back the abbreviation based on the selection from H.

Also, I added a new sheet - info 2() - that simplifies (I think) the summary you have on INFO

[APP123]

thank you very much for the help I believe that will work great

[FDibbins]

Happy to help and thanks for the feedback Did you look at the new sheet I added, is that something you could work with?

[APP123]

yeah I believe Its better than what I had before, im only going to use it for picking up how many times each code is used e.g. AP, IT and then multiply It by 15 to get the time spent doing those tasks, so it should work well

[APP123]

one little question thou, Monday works perfect but the other days have an error on them what do I need to do to make em work

[FDibbins]

If you mean the formula in G, yes, I just noticed a small error. change it to...
=IF(H6="","",INDEX('Info (2)'!$A$3:$A$26,MATCH(H6,Description,0)))

Heres a quick way to do them all. click on Monday, press shift and click on Friday. You have now GROUPED the sheets - what you do on 1 gets done to them all.

Now, copy that formula into Monday G6, and then copy it down as far as you need it. When you are done, click on Info (or any sheet outside the group) to UNGROUP