convert text from Table B to column name in Table A

Hi community!

I have an issue with "concatenate" function when I get the column name from Table B to Table A, when column names come without square brackets, while each of them denotes column names in Table A. The point is that "Concatenate" function does not recognize those texts as actual column name in Table A, while I wish to get the values from those Table A columns.

Any help would be great...

Awaiting community))

Solved Solved
0 6 227
1 ACCEPTED SOLUTION

Unfortunately you are not able to do that. You can't read column names dynamically with a formula.

View solution in original post

6 REPLIES 6
Top Labels in this Space