Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vook Up Table - how to setup
Hi,
I'm trying to setup a spread sheet to keep track of my hockey refing games and how much i've maid. I want to be able to put in what type of game i did in the spread sheet, and then i want the amount i made for that game to be automatically filled in. There are 3 varaibles that determine how mush i make. Age, Division, and whether i Ref or Line the game. So how do i set this up? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Vook Up Table - how to setup
I'd set it up like this:
Age Division Ref/Line Col D Col E Wage/Salary D1 = A1&" "&B1&" "&C1 I'd use the same type of helper column on your primary spreadsheet and do the vlookup off of that. Let us know if you have other questions. "eagle" wrote in message ... Hi, I'm trying to setup a spread sheet to keep track of my hockey refing games and how much i've maid. I want to be able to put in what type of game i did in the spread sheet, and then i want the amount i made for that game to be automatically filled in. There are 3 varaibles that determine how mush i make. Age, Division, and whether i Ref or Line the game. So how do i set this up? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking table in Excel to word | Links and Linking in Excel | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
How to setup a look up table where the lookup_value comes from tw. | Excel Discussion (Misc queries) | |||
how do I setup an excel table that outlines the face of a standar. | Excel Discussion (Misc queries) | |||
Can I setup a league table that automatically updates itself? | Excel Discussion (Misc queries) |