Google Sheets Search

Good evening friends!
Please help: how can you implement GoogleTables search?
For example, there is a column: ID
In the application, a person enters the desired ID, and the program looks for the required ID in GoogleTables, after which it displays data from the second column (for example, an email address)?

I’m trying to make a diagram, but something doesn’t work - I can’t figure out where I’m going wrong :frowning:

1 Like

It sounds like you’re trying to do a VLOOKUP. This video might be helpful:

But also, your repeat while loop has the condition true which means it will either never run or will run forever. When you use a repeat while block, you need to have a condition that can evaluate to true OR false such as something with an operator (____ = ____ or ____ > ____).

1 Like

Try this code.

This code assumes the text to search for only exist once.

1 Like

Phenomenal! Thanks, that’s great!

1 Like

I forgot one thing that will enhance performance for large data tables.

image
In the arrow, which is just after displaying the label or doing whatever you want from the loop. You need to break out of the loop because you already found what you want and there is no need to continue searching.

image

1 Like

Thanks for your support! And for your patience :slight_smile:

1 Like