In cell Sheet1 range M11 put
=OFFSET(Sheet2!E10,MATCH(Sheet2!C11,
{"T1","T2","R1","R2","R3","R4"},0),0)

or substitute the array with the range used to populate
the ComboBox

Kevin Beckham

-----Original Message-----
A workbook has two sheets: Sheet1 and Sheet2

In Sheet1 I want to populate merged cell range M11:AK12
as follows:

If Sheet2, cell C11 = "T1", insert Sheet2!E11 data in
Sheet1 range M11
If Sheet2, cell C11 = "T2", insert Sheet2!E12 data in
Sheet1 range M11
If Sheet2, cell C11 = "R1", insert Sheet2!E13 data in
Sheet1 range M11
If Sheet2, cell C11 = "R2", insert Sheet2!E14 data in
Sheet1 range M11
If Sheet2, cell C11 = "R3", insert Sheet2!E15 data in
Sheet1 range M11
If Sheet2, cell C11 = "R4", insert Sheet2!E16 data in
Sheet1 range M11

As background, Sheet2!C11 is populated by a ComboBox
LinkedCell

What is the code to make this happen?

.