Hi there! Can we create a scenario at Make.com acting like a VLOOKUP in Google Sheets? I have a table with approx 100 records in this structure :
Value
Slug
Name
5
marketing-public-relations
Public Relations
6
marketing-content-copywriting
Content / Copywriting
7
marketing-ecommerce
eCommerce
My scenario is getting “Value” from making an HTTP request. How can I transform this Value into a Name in this case? In Google Sheets, I would use function =VLOOKUP(“5”; A: C;3), but I am looking now for a solution like this in Make.com not to create a 100 Text parse – Replace modules.
Hi @ManishMandot, thanks for the tip! I have developed it slightly, and now, using Search Rows Advanced + adding a row with the result of the previous step works great for me! I am leaving this one for future hunters for a solution:
Congrats on solving this one with the assistance of @ManishMandot
Thanks a lot for remembering to share what you learned with us and for marking your reply as a solution. Thanks to that, the community stays tidy neat, and easy to look for answers.
