Search in Airtable list but show another field of that record

[jccarbonerog]

Hello, I am stuck at this step, as I have the blocks, it shows me the records that contain the word entered in the search engine, but I need another field of that record to be shown, that is, now it shows “Category” and I need it to list "Name "

Thanks Community!

[tatiang]

This question comes up about once a week on the forums. What you’re describing is a VLOOKUP. Here’s one solution for that:

[Solved] A better strategy for a fast VLOOKUP

Due to my work need, I’m using the current blocks to perform a VLOOKUP, it works fine but it’s very slow as the blocks has to loop throw 14k of rows to get the desired value which takes about a couple of Seconds, [Screenshot 2023-10-18 203816] I tried both local data source and google sheet without a difference as both of them are uncomfortably slow. Any better strategy is available for an instant result.