Search a spreadsheet from the values of a array

How To
1

I have a scenario where I am searching from the skus of my products in a specific value within a spreadsheet, how could I do so that it returns a specific column of all the values ​​in the list?

I have the following array:

image

2

Hi @nicocastro,

What you can do is iterate over the SKUs and then do a search in Gsheet which then you can use to grab the column you want.

The other option that you can use is, Use Search Rows(Advanced) and utilize Gsheet search query to do this. Basically, You can write a Query to return Column A, if Column B matches the SKUs that you have.

1 Like