referencing form control data contents in formula

[bmoore45]

Hey guys, pretty much trying to do what the title says.

I have inserted a form control (dropdownlist) and want to refer to its contents in a cell formula;

=IF(dropdownlistcontent="blah","output1",IF(dropdownlistcontent="blah2","output2"))

is there an easy way to do this? I've looked around the developer tab and tried googling but now I'm here

Any help appreciated guys, thx!

ben

 

[AlphaFrog]

You can link the control to a cell (right-click on the control and select Format Control. Then select the Control tab). Then you can use a formula to reference the linked cell.

Say you linked the control to cell A1 then use this formula...

=IF(A1="blah","output1",IF(A1="blah2","output2", ""))

Often the linked cell is the cell that the control is on top of but it doesn't have to be.

 

[bmoore45]

thanks heaps mate this is exactly what I was after!