Steve, if you are good with Excel formulas and can figure out a formula for that - then, in theory, you can use SheetsSet to write a formula to a cell and then use SheetsGet to retrieve the calculated value.

Hmmm, interesting. I'll give that a try. Thanks.

Thank for the tip. I got it working, and it is awesome.

Props for your formula writing skills! Not many people would be able to pull it off.

Hi Steve,
I'm interested in doing exactly the same thing, but not familiar with the lookup "sheetset" formula. Would you be willing to share your formula? I could probably adapt it for my purposes.

Hello. You can look into the VLOOKUP function https://support.google.com/docs/answer/3093318?hl=en and also maybe Steve has any suggestions.

thanks for the guidance. all i want to do is have users enter in their name (that would be my vlookup "search key"...let's say it's in column A of my spreadsheet) and get a value (a link they've provided previously) from column B. but i'm lost here...

i have it working in sheets, i just can't get the javascript right on the storyline end.

In the JavaScript trigger you will do:
SheetsSet('Formula', '=VLOOKUP....');
SheetsGet('Formula', 'varname');

So you are writing a formula to a cell titled "Formula," the value gets calculated as you do it, and then you read the calculated result and save it to a Storyline variable "varname."

If you need more help, please consider starting a new thread so we don't spam Steve with all these messages.

That did it! thanks 🙏🏼🙏🏼🙏🏼