Quick Question: How to select the right colu...

(li zhou) #1

Quick Question:

How to select the right column from several columns by the formula? I want to do some lookup based on the column I select. Thanks!

(Aleksi Alkio) #2

Would you please open your case little more, thanks.

(li zhou) #3

@Aleksi_Alkio Sure. I try to lookup one data from one column by formula. But the column name is not fixed. It also need to be searched by one condition (The column name equal to what I select before). How could I make it happen. Thanks a lot!

(Aleksi Alkio) #4

You would need to create an IF statement with different LOOKUP expressions because you can’t read the column name inside of the LOOKUP dynamically.

(li zhou) #5

@Aleksi_Alkio Thanks! Translate