Hi all,
I’ve 3 (A, B,C) columns with data. In the 4th column (D) i want to select a column by entering A, B or C. With a formule the correct column should be displayed in E. But … i can’t figure it out how to do it 
Like this:
A B C D E
1 2 3 B 2
4 5 6 A 4
7 8 9 C 9
Use this formula in E1 and copy it down to other rows as required.
=INDIRECT(CONCATENATE(D1,ROW(D1)))
This formula creates a string from the content of cell D1 and the current row number (using function ROW). This string is passed to the INDIRECT function. It returns a reference based on a text string.
So, the CONCATENATE functions “calculates” the string “B1”, and the INDIRECT function reads the content of cell “B1” as output of the complete formula.
EDIT: Depending on your local settings, you may need to use a comma “,” instead of a semicolon “;” as separator in the CONCATENATE function:
Thank you very much! Your solution is working
In my case it was =INDIRECT(CONCATENATE(H12;ROW(H12))) (a ; instead of , ).
yes, comma or semicolon as function separator depends on the localisation settings.