Forum Discussion

Jimbobmcwalton's avatar
Jimbobmcwalton
Brass Contributor
Jan 08, 2019

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

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 a...
excel
Formulas and Functions
training
TJalbert's avatar
TJalbert
Copper Contributor
Jan 08, 2019

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

 

 

 

Jimbobmcwalton's avatar
Jimbobmcwalton
Brass Contributor
Jan 09, 2019

Thanks TJ,

 

I tried that last week but maybe due to the source data tab being in table format (i dont know) it tells me that it shoudl be a single list.

 

I have attached the sheet I will be using next month and reduced the accounts & couriers to just a couple so you can have a look and see what I am trying to do.  I have added the A/C Type and Sales Person Fields to the source tab I am trying to get the relevent data from so you can see the 3 types of accounts and the 3 sales people.

 

Thanks for your help 

 

Thanks for your help 

    • Jimbobmcwalton's avatar
      Jimbobmcwalton
      Brass Contributor
      Jan 21, 2019

      Hi Tim,

       

      Sorry, I have been away.

       

      Thanks for the reply.  I can see you have put Iforceco in one of the cells but don’t see the connection.

       

      Could you elaborate for me, I don’t understand.

       

      Thanks in advance

       

      Jim

Resources