Hello everybody!
In google sheets, I can perform a lookup with the find-value expresion โ(asteriskcharacter)โ&[whatever]&"(asteriskcharacter)". This way, the function looks for a cell that contains the A2 value, not only the exact text of A2.
for example, if I look for a code like โcdh002154โ, I need it to be found if there is a value like โcdh002154cdh002155โ in the reference table.
Any ideas?
Solved! Go to Solution.
Wow, thank you! I had been reading about this functions, but didnt find anything. Since you point them as a solution, I tried harderโฆ and I think I got it!
Instead of a lookup function, I used a Select(table[desiredoutputvalue];contains ([referencecolumn];[_thisrow].[valuetofind]]
Well, I am not sure if I explain it right, but the fact is that it worked perfectly,
Thank you!
Wow, thank you! I had been reading about this functions, but didnt find anything. Since you point them as a solution, I tried harderโฆ and I think I got it!
Instead of a lookup function, I used a Select(table[desiredoutputvalue];contains ([referencecolumn];[_thisrow].[valuetofind]]
Well, I am not sure if I explain it right, but the fact is that it worked perfectly,
Thank you!
User | Count |
---|---|
33 | |
25 | |
22 | |
21 | |
15 |