Google Script: Searching with a cell value

I want to add +1 to a value from a customer.

As example:

| G8 | K8 |

| Max Mustermann | 140 |

Goal:

| G8 | K8 |

| Max Mustermann | 141 |

I have a Script that works fine, but I would like to use the value (Max Mustermann) from a cell (G5).

function TextFinden() {
var spreadsheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet()
spreadsheet.getRange("G8:G" + spreadsheet.getLastRow()).createTextFinder("Max Mustermann").matchEntireCell(true).findNext().offset(0, 4).activate();

//value +1
var cell = SpreadsheetApp.getActiveSheet().getActiveCell();
var value = cell.getValue() * 1;
cell.setValue(value+1);
}

Goal example:

createTextFinder("G5")

So, I can write the Name in a cell (G5) and use a Button to add +1 to the Customer.

Any advice will be appreciated, thanks.

I believe your goal is as follows.

• You want to retrieve a value from cell "G5".
• You want to search the value from cells "G8:G".
• When the value is found, you wan to add 1 to the column "K" of the same row.

In this case, how about the following sample script?

Sample script:

function myFunction() {
  const sheet = SpreadsheetApp.getActiveSheet();
  const value = sheet.getRange("G5").getDisplayValue();
  const range = sheet.getRange("G8:G" + sheet.getLastRow()).createTextFinder(value).matchEntireCell(true).findNext();
  if (!range) return;
  const valueRange = range.offset(0, 4);
  valueRange.setValue(valueRange.getValue() + 1);
}

Note:

• If the value of column "K" is the string value, please modify valueRange.setValue(valueRange.getValue() + 1) to valueRange.setValue(Number(valueRange.getValue()) + 1)

References:

• createTextFinder(findText) of Class Range
• offset(rowOffset, columnOffset)