Dear reader,

Here is my problem:

I have one already filled table on the right (column A, B, C and D) and I want to put some of these data (from column A, D and C) in a new table (left). This is based on data in column E and whenever I want to place data from right column A row X into left column A row Z I also want to fill in the data from right column C row X into left column C row Z and the same for columns D. See below for an example.

Is there a formula that I can use that automatically fills in the left columns D and C, based on what I fill in in the left column A?

A E D C A B C D
3 other data # c 1 A a !
10 other data ) j 2 B b @
other data 3 C c #
other data 4 D d $
other data 5 E e %
other data 6 F f ^
other data 7 G g &
other data 8 H h *
other data 9 I i (
other data 10 J j )


Thank you in advance!

Best,
Susann