Forum Discussion
Entering a formula to Enter a Text Value in a different cell dependant on drop down box entry
Hi Jimbob,
I would setup a vlookup with the 45 options. See attached, does this work?
Tim
Thanks for the Reply TJ
I did look at this but my look up value changes each time, with each different row - should this still work if this is the case?
Version 2 Attached
Can you give me a better picture of the setup of your woksheet? If I know how the data is entered and how the "word" is displayed I can provide a solution.
Tim
Sure, maybe I should explain what it does a little better :) , I have a drop down list of 45 accounts, each account is selected from a list on a seperate sheet (which gets added to each week or so) From this dropdown list we then select the account thats booking a job.
We have 3 types of job for all accounts SameDay Dedicated or Route Cover and each account is attributed to one of 3 sales persons. On Each account I would like these factors attributed to each of the accounts.
EG Account Sales Person Account Type
Aviva John SameDay Dedicated
Currently we have to add in the account type & sales person manually but they never change so I would like the Sales Person & Account Type to be filled in in the correct cells.
Hope this makes sense
Thanks in advance
Jim
Many Thanks
ok, I hope that I got all of the moving parts!
I suggest that you have one tab (and maybe you already do) to set up the account info that doesn't change. Then each week when you select a particular account, the static info doesn't change but is automatically filled in.
See attached. This would probably go quicker is you could send a blank copy of your model or screen shots! :)
Tim