Google Sheets - find in column and increase another cell on same row
-1
I have been looking high and low for a script to modify to my needs as I usually work on a script and modify others, but in this case I have had no luck so just seeing if someone can direct me in the right direction. I have a SKU in cell (Add Stock)E13 than I need to find in another sheet Products(B:B). Once it finds the value in Products(B:B), it needs to add a 1 value to Products(H) of the same row, as in it is adding one to the "In Stock" level. I was playing with some loops but it was taking time to search the column as it has 20,000 rows and was taking too long.
javascript google-sheets
share | improve this question
asked Nov 20 at 7:34
...
