Forum Discussion
Is it possible to create a formula if cell 'a1' contains 'word' the adjacent cell populates a value
Is it possible to create a formula if cell 'a1' contains 'word' the adjacent cell 'b1' populates a value I have a sheet containing a drop down list which when each option is selected I want the a...
=INDEX($G$3:$G$27,MATCH($A$1,$F$3:$F$27,0))
You can set up a reference list and apply this formula in cell B1.