Profile cover photo
Profile photo
Graeme Henson
83 followers -
At least it's not facebook!
At least it's not facebook!

83 followers
About
Posts

Help with copying over some cells:

I've got a formula in one cell doing a VLOOKUP across a range of cells with Strings. On another page I'm running a script to copyTo from that VLOOKUP cell onto another cell on the target sheet. I want the actual output to be the String that the VLOOKUP is showing, not the actual VLOOKUP formula itself (which is what I'm seeing now). Any idea on how I can go about that? Here's the code I currently have:


try {
var ssh = SpreadsheetApp.getActiveSpreadsheet(); // Source spreadsheet
var msns = ssh.getSheetByName("Missions");
var msnsgen = ssh.getSheetByName("Mission Generator");
var ms = msns.getRange("d2");
ms.copyTo(msnsgen.getRange("b4")); // Copy source
}
catch(err) {
Logger.log(err);
}

}



(for reference, the d2 formula is [=VLOOKUP(A2,A3:D90,4,FALSE)])

Post has attachment
Maybe this is old news that I missed, but there's a board gaming parlour opening up here in Columbus. They're running a Kickstarter now til January 15.

Post has attachment
Shia Labeouf is either a chronic plagiarist or we're all getting punked right now.
Add a comment...

Post has attachment
The process of Design, though my semi-OCD self is bothered by that lower-right angled line.

Squiggle by Damien Newman
Photo
Add a comment...

Post has attachment
I hadn't considered this option before.
Add a comment...

#humblebundle  needs to stop existing. It won't make me broke, but I'll never have the chance to play all these games in my lifetime.
Add a comment...

Can I stop seeing Doctor Who spoilers for Day of the Doctor? I'm a couple seasons behind and it's bad enough I know that Matt Smith is going to ***. Sometimes Internet, you need to know when to keep your stupid mouth shut.
Add a comment...

Post has attachment
Here's looking at you Johnny FK.
Add a comment...

Post has attachment
Not the best deal available apparently, but almost picked up a $13.00 copy of King of Tokyo from this. Curse you Clan Walton!
Wait while more posts are being loaded