after discussion with another member it was decided my first post was vague, so now I included a depersonalized file with some test name ranges so it is clearer at what I'm attempting. On ShIL02 in cell (Q8) is the result from what I choose in combo box named (Namecb1) on the same worksheet. That combo box is populated from the results of a macro my daughter-in-law wrote for me (results are listed in A8:A155 on the same worksheet). She and my son are on Navy tour of duty at sea so any communication I have with them I keep to family matters so asking for her help is not possible (I have limited VBA experience) That list is then named (list.namedranges) which is then feeding info. to combo box (Namecb1) also on the same worksheet. The results in cell Q8 I wish to be the values from the name range I choose in the combo box. There might be several values per name range and those I wish to be continued listed down column Q. I cannot ask my daughter-in-law for help and I'm not going to wait another 4 months to ask her.