Paste Table based on CHOOSE value

[snapfade]

Good Morning,

My very large document uses the CHOOSE function in many places to paste content based on the value of a COMBOBOX at the beginning of the document.

My problem is that I now need to paste an entire table for a certain CHOOSE function value. Documentation for the CHOOSE function allows reference to a range of cells such as A1:B12, however, I cannot get it to paste the table in the document.

Any suggestions? Is there perhaps another solution that I have overlooked?

Thanks in advance for your help!

[mikeTRON]

Post a sample workbook with a proposed layout of the solution.

[snapfade]

Hi Mike,

I'm sorry but that would be very involved because I would have to create a sample file. I will try to explain in more detail.

The main document is on Sheet1.
The COMBOBOX is used by the user to choose a name.
The number of that choice is the input value of CHOOSE.
In most cases, a word or line of text is pasted as the result of the CHOOSE function. Works perfectly.
In this case, instead of a line of text I need to paste an entire table, from Sheet2, cells A1:B12.

In practice, if the user chooses any of 15 names, the CHOOSE function pastes a corresponding value from the Sheet2 reference area. If the user selects the 16th name then I need to paste that table instead of a word or line of text.

Does this help, Mike?

Thanks for checking this out.