Forum Discussion
lookupvalue
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...
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"))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