Thread: Drop down selection which influences value in an adjacent column
View Single Post
 
Old 08-06-2018, 07:22 AM
lyndap2 lyndap2 is offline Windows 10 Office 2016
Novice
  
Join Date: Aug 2018
Posts: 1
lyndap2 is on a distinguished road
Default Drop down selection which influences value in an adjacent column
Hi

I am working on a register & want it to allow options to be chosen from a drop down list, but dependant on which option is chosen, a different response between 0-3 is auto filled in a column elsewhere in the table.

would this be something to do with the 'IF' formula?

Any advice appreciated as its starting to swamp my brain!
Reply With Quote