Hi All 

Thanks for taking the time to read this, unfortunately I’m unable to achieve what i would like so hopefully someone can help. I would like to populate two different cells from whichever dropdown option I select based on data from another sheet. I can’t figure out how to link the cells to the dropdown option, and correlate that to the data.  See below, when I select a dropdown option (C15) I would like it to fill the cells RX Freq (F15) & TX Freq (I15) dependant on the channel I select. 

I have linked the channel cell to my sheet with the data and now have the options in dropdown form. The top image is from one sheet, the values are in another called ‘data’.

Any help much appreciated.

​Hi All   Thanks for taking the time to read this, unfortunately I’m unable to achieve what i would like so hopefully someone can help. I would like to populate two different cells from whichever dropdown option I select based on data from another sheet. I can’t figure out how to link the cells to the dropdown option, and correlate that to the data.  See below, when I select a dropdown option (C15) I would like it to fill the cells RX Freq (F15) & TX Freq (I15) dependant on the channel I select.  I have linked the channel cell to my sheet with the data and now have the options in dropdown form. The top image is from one sheet, the values are in another called ‘data’.  Any help much appreciated.  Read More

​