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

[li_zhou]

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]

Would you please open your case little more, thanks.

[li_zhou]

@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]

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.

[Yogesh_laddha]

It would be very useful if we can read the column name inside of the LOOKUP dynamically.

Is there anyway around it? I want to select the columns name dynamically based on the USEREMAIL().

[Steve]

To do what I think you want, you would need to wrap the LOOKUP() in a conditional, e.g.:

SWITCH(
  USEREMAIL(),
  useremail1, LOOKUP(...),
  useremail2, LOOKUP(...),
  ...
)

You CANNOT do this:

LOOKUP(
  lookup-value,
  table,
  SWITCH(...),
  return-column
)

[li_zhou]

@Aleksi_Alkio Thanks! Translate