Hi Excel Forum,

I have a table B2:E8.

In C12 and D12, if I input (and not use a drop-down), say A, under ORIGIN, I would like C14:19 to populate from the table B2:E8.

How can i do this? Appreciate your help!

Sorry, for some reason, i could not get the attachment button to work in chrome and IE. So, i have to work with an image.

Patrick


exceltable.png