lookupvalue

[Norbertus]

I need a function to lookup a value from an another table. In this function i need to search for a part of string and give back a second column. At this moment i made a calculated column with all the different options, but the list is growing.

group =

if(SEARCH("*bike*",table[column],,0);"supllier x",

if(SEARCH("*car*",table[colum],,0),"supplier y", 

"unknown"))

something like this:

table 1:

bike     supllier x
car      supllier y

table 2
bike_123  ===>> result supllier x

[austinsense]

Maybe you're looking for the LOOKUPVALUE function https://msdn.microsoft.com/en-us/library/gg492170.aspx.

You might need either 1) to create a column in table 2 that has the same terms as table 1 (ie bike, car, etc) so that you can do the match or 2) write an expression that returns the string you want to search for - you're close but replace the output with the argument you're searching for ...

group =
if(SEARCH("*bike*",table[column],,0);"bike",
if(SEARCH("*car*",table[colum],,0),"car", 
"unknown"))

[Norbertus]

The lookupvalue has a part "search_columnName". This can't be an expression. I need a function that can search for * or % in the value