Mastering VLOOKUP in Make.com: A Guide for Users

Have you ever found yourself in a situation where you need to perform a VLOOKUP-like operation in Make.com, but you're not sure how to go about it? Well, you're not alone. This is a common challenge that many Make.com users face, especially when dealing with large datasets.

Problem

Let's say you have a table with approximately 100 records structured like this:

ValueSlugName
5marketing-public-relationsPublic Relations
6marketing-content-copywritingContent / Copywriting
7marketing-ecommerceeCommerce

Your scenario involves getting a "Value” from making an HTTP request. The challenge is to transform this Value into a Name. In Google Sheets, you would use the function =VLOOKUP("5”; A: C;3), but how can you achieve a similar result in Make.com without creating 100 Text parse – Replace modules?

Solution

The solution to this problem is simpler than you might think. You can use the Search Rows module and use specific column search. This approach is straightforward and efficient, saving you the hassle of creating numerous Text parse – Replace modules.

Here's a step-by-step guide on how to do it:

  1. Go to the Search Rows module in Make.com.
  2. Select the specific column you want to search in.
  3. Enter the value you're looking for.
  4. Make.com will return the corresponding Name for the Value you entered.

Troubleshooting Tips

If you're having trouble with the Search Rows module, here are a few tips that might help:

  • Make sure you've selected the correct column to search in.
  • Ensure the value you're searching for exists in the selected column.
  • If you're still having trouble, try using the Search Rows Advanced module for more complex searches.

Conclusion

Performing a VLOOKUP-like operation in Make.com is a breeze once you know how to use the Search Rows module. This method is efficient, easy to use, and a great time-saver, especially when dealing with large datasets. So the next time you find yourself needing to transform a Value into a Name in Make.com, remember to use the Search Rows module. Happy Making!

You do have further questions?

Ask your question via E-Mail: Richard@make-app.de
Book a paid Support & Consulting Session
New Make.com user? Sign up through this Affiliate Link to receive 10.000 operations for FREE.