budrowilson
New Member
- Joined
- Jan 6, 2017
- Messages
- 4
Hi there!
A friend of mine is participating in a scavenger hunt where she can score points based on road signs using Scrabble scoring. I was hoping to create a spreadsheet where she can figure out what are the most valuable roads in a city where she travels to so that she can optimally spend her time there. Finding the names of the roads in a place is relatively easy, as is creating the Scrabble letter value lookup table.
I've done quite a bit of research into analyzing the individual characters in a cell, but most of the resources are adding the numerical values located in a single cell. What I'm needing to do is loop through the characters, using a VLOOKUP to find the values of those characters, then output the sum of those values.
My road names start in E:4 and my Scrabble lookup table is 'Scrabble Legend'!$A$1:$B$27.
A sample road name might be "ash", which would total 6 points (a[1] + s[1] + 4[h]).
Thoughts?
A friend of mine is participating in a scavenger hunt where she can score points based on road signs using Scrabble scoring. I was hoping to create a spreadsheet where she can figure out what are the most valuable roads in a city where she travels to so that she can optimally spend her time there. Finding the names of the roads in a place is relatively easy, as is creating the Scrabble letter value lookup table.
I've done quite a bit of research into analyzing the individual characters in a cell, but most of the resources are adding the numerical values located in a single cell. What I'm needing to do is loop through the characters, using a VLOOKUP to find the values of those characters, then output the sum of those values.
My road names start in E:4 and my Scrabble lookup table is 'Scrabble Legend'!$A$1:$B$27.
A sample road name might be "ash", which would total 6 points (a[1] + s[1] + 4[h]).
Thoughts?