I have a drop down with the following: Bin Run, Single Clean, Single Clean Bagged.
I want to populate Cell G41 With contents from cell I18 when my dropdown says "Bin Run". I have this formula as follows and it seems to work.
=IF(G40= "Bin Run",I18)
but now i want to populate cell G41 with contents from cell T25 When G40 or my drop down says "Single Clean". Similarly with "Single Clean Bagged".