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 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
2 Replies
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"))
