Google Sheet App Script: Match two values from one sheet to another sheet and then set a value if th-CodePudding

Home > Blockchain > Google Sheet App Script: Match two values from one sheet to another sheet and then set a value if th

Google Sheet App Script: Match two values from one sheet to another sheet and then set a value if th

Time：04-21

very new to app script but well versed in formulas and so up-skilling.

For reference I've made a test sheet

Input in Sheet2

Result

Output Sheet1

Output Sheet2

Page link：https//www.codepudding.com/Blockchain/379335.html

Prev:Date Stamp in multiple Columns Google Sheets

Next:How to get the value from another sheet with variable sheet name using Google Sheets?

Tags：

google-apps-script

Related

Links：
CodePudding