Hi John,

Thanks very much for your prompt and kind response.

I followed your instructions/steps above, but unfortunately, I could not get it to work.

I created the Named Range in column A of 'Products' sheet and assigned the offset formula as you instructed. I also copied and pasted the code into the Sheet1 Module. But nothing shows up in any of the combo boxes. I don't know what I am doing wrong.

Is it possible you could test it all for me, please, using a copy of the sample file that I uploaded. If you get it to work, I'd be happy to use your working copy uploaded back.

Thanks very much for your help.

Newqueen