Entering a formula to Enter a Text Value in a different cell dependant on drop down box entry

Question

Been trying to get my worksheet to automatically enter a "Word" in a column based on the value of a drop down box currently containing 45 options. I tried the IF function but I think I need to put all 45 options in the formula to get this to work and that cant be the best way ?

I have the drop down list that gets the data from a different sheet, this data grows as time goes on.

Its simply to add in a sales persons name depending on which account we are inputting on the sheet as I have to do this manually at the end of each month to create pivot charts.

Can anyone help ?

tjalbert · Answer

Hi Jimbob,&nbsp;I would setup a vlookup with the 45 options.&nbsp; See attached, does this work?&nbsp;Tim

jimbobmcwalton · Answer

Thanks for the Reply TJ&nbsp;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?

tjalbert · Answer

Version 2 Attached&nbsp;Can you give me a better picture of the setup of your woksheet?&nbsp; If I know how the data is entered and how the "word" is displayed I can provide a solution.&nbsp;Tim

jimbobmcwalton · Answer

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)&nbsp; From this dropdown list we then select the account thats booking a job.&nbsp;&nbsp;&nbsp;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.&nbsp; On Each account I would like these factors attributed to each of the accounts.&nbsp;EG&nbsp; Account&nbsp; &nbsp; &nbsp; &nbsp;Sales Person&nbsp; &nbsp; Account Type&nbsp; &nbsp; &nbsp; Aviva&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; John&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SameDay Dedicated&nbsp;&nbsp;Currently we have to add in the account type &amp; sales person manually but they never change so I would like the Sales Person &amp; Account Type to be filled in in the correct cells.&nbsp;Hope this makes sense&nbsp;&nbsp;Thanks in advance&nbsp;&nbsp;Jim&nbsp;Many Thanks&nbsp;

tjalbert · Answer

ok, I hope that I got all of the moving parts!&nbsp;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.&nbsp;See attached.&nbsp; This would probably go quicker is you could send a blank copy of your model or screen shots! :)Tim&nbsp;&nbsp;&nbsp;

Forum Discussion

Entering a formula to Enter a Text Value in a different cell dependant on drop down box entry

Share

Resources