Populating a column from a table after category selection

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

Many thanks, XLent!! I will try it!

Originally Posted by XLent

one option:

Formula:

Please Login or Register  to view this content.

edit: if the values in B14:B19 do not always mirror the order of the same in A3:A8 you can replace the ROWS reference with a MATCH, i.e.

Formula:

Please Login or Register  to view this content.