Can I select columns dynamicaly based in user input?

[Jorge_Cambero]

Hi, I have 2 data bases A and B, A is used to do searches in B. Is there a way to do a pick a column of B dynamicaly based in the value of a column in A?

[Marc_Dillon · Accepted solution]

There's no way to dynamically refer to different columns. You have to do something like this.

SWITCH( [col] ,
  'x' , LOOKUP( val , table , col , x ) ,
  'y' , LOOKUP( val , table , col , y ) ,
  'z' , LOOKUP( val , table , col , z )
  ...
)