Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread Display Modes
Old Apr 2, 2013, 11:59 AM   #1
macrumors newbie
Join Date: Mar 2012
Location: Brightwood, Oregon
Entering a numerical value for text

I am organizing a football pool, and I would like to find a way to assign a team name a numerical value. For example, each person chooses 6 teams from different groups, and each team gets 2 points for a win. When I do the quarterly updates, I would like to be able to tell the sheet that each "San Fran" cell should equal '12' or each "Seattle" cell should equal '16'. I am not sure if this is possible, but any help would be greatly appreciated (and save me about 2 hours of data entry per quarter during the football season!). I have a good understanding of the Excel program, but I am not very good with the technical language that I have seen so far on these boards. I am running Office for Mac 2011. Thank you!
MtnGirl is offline   0 Reply With Quote
Old Apr 2, 2013, 12:17 PM   #2
macrumors newbie
Join Date: Mar 2013
Sounds like you need to setup a separate table where you say what you have team names in the first column, then apply the values you want to each team in the second column.

Then use VLOOKUP to add those values to each persons team.

Or use google to find some templates.....

Moakesy is offline   0 Reply With Quote
Old Apr 3, 2013, 10:12 AM   #3
macrumors 6502
Join Date: Dec 2011
Location: Winnipeg
Moakesy is exactly on the right track suggesting a VLOOKUP, if you are not sure, here is how to set it up.

The first image represents your main sheet showing who picked which teams, the second image is your lookup table (sheet 2) where you enter the points for the teams. You could go further with this and enter the game schedule in the columns to the right (Game 1 - Column D, Game 2 - Column E etc..) and have a SUM statement in your points column (Column B) automatically adding up the points as you enter them.
Attached Thumbnails
Click image for larger version

Name:	VLOOKUP_1.jpg
Views:	17
Size:	98.8 KB
ID:	406024   Click image for larger version

Name:	VLOOKUP_3.jpg
Views:	18
Size:	94.6 KB
ID:	406025  
 17" 2011 MacBook Pro, 2.3 GHz i7 Quad, 16GB, Intel 520 240GB SSD
 11" 2012 MacBook Air, 1.7 GHz i5 Duo, 4GB, 128GB
 4th. Gen. iPad, 16GB, WiFi  4th. Gen. TC, 2GB
prisstratton is offline   0 Reply With Quote

MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Mac Pro configuration for numerical computing with Matlab msvadi Mac Pro 4 May 13, 2014 08:30 PM
iPod Touch: use viber without entering appleid vlink Jailbreaks and iOS Hacks 1 May 2, 2014 07:47 AM
Numerical signal strength gone? Nacket iOS 7 4 Oct 24, 2013 11:35 PM
Numerical file (photo) ordering when using Preview jgc OS X 1 Jan 30, 2013 07:11 AM
Have to keep entering password on OS X 10.8 siricorrine OS X 10.8 Mountain Lion 1 Dec 31, 2012 10:50 AM

Forum Jump

All times are GMT -5. The time now is 07:43 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2015, MacRumors.com, LLC