Search in Airtable list but show another field of that record

[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.