Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Drop down selection which influences value in an adjacent column
Register FAQ

Reply
 
Thread Tools Display Modes
  #1  
Old 08-06-2018, 07:22 AM
lyndap2 lyndap2 is offline Drop down selection which influences value in an adjacent column Windows 10 Drop down selection which influences value in an adjacent column Office 2016
Novice
Drop down selection which influences value in an adjacent column 		 
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
  #2  
Old 08-06-2018, 12:08 PM
xor xor is offline Drop down selection which influences value in an adjacent column Windows 10 Drop down selection which influences value in an adjacent column Office 2016
Expert
  
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default
Maybe the attached can be of help.
Attached Files
File Type: xlsx DropDown.xlsx (8.9 KB, 13 views)
Reply With Quote
Reply

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF adjacent cell empty Copy from Other Column ChrisOK Excel Programming 8 03-08-2018 09:17 PM
Drop down selection which influences value in an adjacent column Drop down lists and pulling data from worksheet based on drop down selection cjoyce73 Excel 5 07-17-2017 07:40 AM
How to "hard link" two adjacent cells to a data validation drop down list? Geza59 Excel 10 10-19-2012 11:56 AM
Drop down selection which influences value in an adjacent column Macro ? - Checkbox in Word + drop down selection help dice1976 Word 4 07-24-2012 11:18 AM
Ho to perform multi selection in drop down lists? nashville Word 0 09-29-2010 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 AM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft