1
Expand VLOOKUP to return text values
- Open
- Subscribe
|
S |
Stefan Klijn |
It would be great to expand the VLOOKUP functionality. At the moment, the VLOOKUP function only supports returning numeric values.
It would be extremely helpful if this functionality could be expanded to also return text values.
Being able to use VLOOKUP for both numbers and text would greatly increase its flexibility and allow for broader use in general lookup scenarios, like returning article descriptions.
I hope you will consider this enhancement for a future update.
Activity Newest / Oldest
Stefan Klijn
Hello Florian,
Than you for your swift response.
Usecase is as follows:
Customer answers a questionaire.
With the given answers we calculate the parts/articles needed. For this we make use of a data table and VLOOKUP.
End result will be a list of partnumbers, part descriptions and prices. These are all present in the data table.
I will contact support regarding this use case, and will place any updates here.
Florian involve me
Hello Stefan,
VLOOKUP is a mathematical function that can be used in the calculator element, the final result of the calculator formula is always a number. VLOOKUP can also return a string/text if that result is compared to a string (eg inside the CONTAINS which is used in IF/ELSE), ultimately this will always need to calculate a number. If you need to return text from the table, probably you are looking for the Autocomplete function features.involve.me/b/content-element-suggestions/auto-complete/
Feel free to chat with support to get more background information or discuss your use case