Hi all,
I can normally stumble through these things or at least get 90% of the way there but am at a loss on this one and would appreciate your help.
This is my current formula:
I want the first part to remain as it is. For the False part of the IF formula, however, I want it to return the same value currently but also allow a drop down box with a number of options. Basically, the result from the original formula is the default option but other upgrade options are available.
In sheet 'Bolted Base' each cell in the range C9:C36 will either be "Yes" or "No". For every cell in this range that is "Yes", I want the text in respective cells A9:A36 to be in the drop down box.
I'm now finally operating on Office365 and so have a few extra functions than I am used to.
The spreadsheet is a big one and I would like to avoid adding extra columns/helper cells. There is actually more to complicate it than I have specified above but I know if I can get this one issue resolved I will be able to manage/adapt the rest myself.
Thanks.
I can normally stumble through these things or at least get 90% of the way there but am at a loss on this one and would appreciate your help.
This is my current formula:
Excel Formula:
=IF(@'Bolted Base'!C38="None",'Bolted Base'!C39,'Bolted Base'!C38)
I want the first part to remain as it is. For the False part of the IF formula, however, I want it to return the same value currently but also allow a drop down box with a number of options. Basically, the result from the original formula is the default option but other upgrade options are available.
In sheet 'Bolted Base' each cell in the range C9:C36 will either be "Yes" or "No". For every cell in this range that is "Yes", I want the text in respective cells A9:A36 to be in the drop down box.
I'm now finally operating on Office365 and so have a few extra functions than I am used to.
The spreadsheet is a big one and I would like to avoid adding extra columns/helper cells. There is actually more to complicate it than I have specified above but I know if I can get this one issue resolved I will be able to manage/adapt the rest myself.
Thanks.
Last edited: