Match and Index Functions HELP!!!

[bababooey03]

I been working on this step for the last 2 days and I am unable to get the formula to work. Tried various versions and cant get the right command / formula. Can someone help. New at Excel so any assistance would be appreciated. Here is the question in a Lab I am doing. There are 9 steps and I can do all of them without any issues but the one step:

Enter a formula for commission that calculates the commission based upon multiplying sales times the appropriate commission from the data in A26:B28. Use [@Column_title] referencing and the INDEX and MATCH functions for looking up data in the A26:B28 cell range

This is what I have been trying or had come up with but they are invalid:

=[@[sales]]*=INDEX(A26:B28, MATCH(A7,A8:F20,0)



I tried pasting a copy of my spreadsheet on here but dont see the option to insert the file or sceenprint

 

[Smitty]

Welcome to the Board!

If you follow the link beneath my sig you'll be able to post a shot of your sheet.

 

[T. Valko]

I been working on this step for the last 2 days and I am unable to get the formula to work. Tried various versions and cant get the right command / formula. Can someone help. New at Excel so any assistance would be appreciated. Here is the question in a Lab I am doing. There are 9 steps and I can do all of them without any issues but the one step:

Enter a formula for commission that calculates the commission based upon multiplying sales times the appropriate commission from the data in A26:B28. Use [@Column_title] referencing and the INDEX and MATCH functions for looking up data in the A26:B28 cell range

This is what I have been trying or had come up with but they are invalid:

=[@[sales]]*=INDEX(A26:B28, MATCH(A7,A8:F20,0)



I tried pasting a copy of my spreadsheet on here but dont see the option to insert the file or sceenprint

I hate structured referencing and NEVER use it so I'll assume that this expression is correct:

[@[sales]]

The probem is with the rest of the formula.

The lookup_array in the MATCH function has to be a 1 dimensional array (a single row or column).

Also, you're indexing a 2 dimensional array but you're only trying to "find" the row with the MATCH function. You either need to define which column the result should come from or just index a 1 dimensional array.

Also, you have an extra equal sign before INDEX.

 

[bababooey03]

Hello Smitty and thank you for the welcome. Here is a screen shot of what my spreadsheet looks like.


Excel 2010
<TABLE style="BORDER-BOTTOM: #bbb 1px solid; BORDER-LEFT: #bbb 1px solid; BACKGROUND-COLOR: #ffffff; BORDER-COLLAPSE: collapse; BORDER-TOP: #bbb 1px solid; BORDER-RIGHT: #bbb 1px solid" rules=all cellPadding=2><COLGROUP><COL style="BACKGROUND-COLOR: #dae7f5" width=25><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #dae7f5; COLOR: #161120"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>H</TH></TR></THEAD><TBODY><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">1</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">2</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">3</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">4</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">5</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">6</TD><TD style="COLOR: #e26b0a; FONT-WEIGHT: bold">Anderson Scholastic Employees</TD><TD style="COLOR: #e26b0a; FONT-WEIGHT: bold"></TD><TD style="COLOR: #e26b0a; FONT-WEIGHT: bold"></TD><TD style="COLOR: #e26b0a; FONT-WEIGHT: bold"></TD><TD style="COLOR: #e26b0a; FONT-WEIGHT: bold"></TD><TD style="COLOR: #e26b0a; FONT-WEIGHT: bold"></TD><TD style="COLOR: #e26b0a; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; COLOR: #e26b0a; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">7</TD><TD style="BORDER-BOTTOM: black 1px solid; FONT-WEIGHT: bold">Dept</TD><TD style="BORDER-BOTTOM: black 1px solid; FONT-WEIGHT: bold">Lname</TD><TD style="BORDER-BOTTOM: black 1px solid; FONT-WEIGHT: bold">Fname</TD><TD style="BORDER-BOTTOM: black 1px solid; FONT-WEIGHT: bold">Age</TD><TD style="BORDER-BOTTOM: black 1px solid; FONT-WEIGHT: bold">Gender</TD><TD style="BORDER-BOTTOM: black 1px solid; FONT-WEIGHT: bold">Sales</TD><TD style="BORDER-BOTTOM: black 1px solid; FONT-WEIGHT: bold">Commission</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">8</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">K-12</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Day </TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Janice</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">32</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">F</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">1,075,800 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">9</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Higer Ed</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Angston</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Lee</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">27</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">M</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">5,500,400 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">10</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">K-12</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Wyler</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Deshanet</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">56</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">F</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">1,589,000 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">11</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Trade</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Cole </TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Arlene</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">30</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">F</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">11,500,000 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">12</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">K-12</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Ruiz</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Jorge</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">39</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">M</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">5,347,500 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">13</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Higer Ed</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Grazier</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Kim</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">25</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">F</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">3,005,000 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">14</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">K-12</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Lipes</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Jim</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">57</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">M</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">2,300,500 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">15</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">K-12</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Steinberg</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Josh</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">28</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">M</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">2,500,000 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">16</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">K-12</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Beam</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Saul</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">34</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">M</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">5,500,000 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">17</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Trade</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Yenkle</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Lisa</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">33</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">F</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">3,200,000 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">18</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Trade</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Wyler</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Len</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">38</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">M</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">10,900,000 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">19</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Higer Ed</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Stavish</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Napoleon</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">47</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">M</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">5,890,000 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">20</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Higer Ed</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Goldberg</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Joan</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">62</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">F</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">3,000,000 </TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid"></TD><TD style="TEXT-ALIGN: right; BORDER-LEFT: black 1px solid; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">21</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">22</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">23</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">24</TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">25</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f79646; COLOR: #ffffff; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-RIGHT: black 1px solid">Dept</TD><TD style="BORDER-BOTTOM: black 1px solid; BORDER-LEFT: black 1px solid; BACKGROUND-COLOR: #f79646; COLOR: #ffffff; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">Rate</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">26</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">K-12</TD><TD style="TEXT-ALIGN: right; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">6.50%</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">27</TD><TD style="FONT-WEIGHT: bold">Higher Ed</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold">7.50%</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR><TR><TD style="TEXT-ALIGN: center; COLOR: #161120">28</TD><TD style="FONT-WEIGHT: bold">Trade</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold">8.50%</TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: right; FONT-WEIGHT: bold"></TD></TR></TBODY></TABLE>

Anderson Scholastic Employees​

 

[Aladin Akyurek]

G8 would be:

=F8*INDEX($B$26:$B$28,MATCH(A8,$A$26:$A$28,0))

 

[T. Valko]

Hello Smitty and thank you for the welcome. Here is a screen shot of what my spreadsheet looks like.


Excel 2010
<TABLE style="BORDER-RIGHT: #bbb 1px solid; BORDER-TOP: #bbb 1px solid; BORDER-LEFT: #bbb 1px solid; BORDER-BOTTOM: #bbb 1px solid; BORDER-COLLAPSE: collapse; BACKGROUND-COLOR: #ffffff" cellPadding=2 rules=all><COLGROUP><COL style="BACKGROUND-COLOR: #dae7f5" width=25><COL><COL><COL><COL><COL><COL><COL><COL></COLGROUP><THEAD><TR style="COLOR: #161120; BACKGROUND-COLOR: #dae7f5; TEXT-ALIGN: center"><TH></TH><TH>A</TH><TH>B</TH><TH>C</TH><TH>D</TH><TH>E</TH><TH>F</TH><TH>G</TH><TH>H</TH></TR></THEAD><TBODY><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">1</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">2</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">3</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">4</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">5</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">6</TD><TD style="FONT-WEIGHT: bold; COLOR: #e26b0a">Anderson Scholastic Employees</TD><TD style="FONT-WEIGHT: bold; COLOR: #e26b0a"></TD><TD style="FONT-WEIGHT: bold; COLOR: #e26b0a"></TD><TD style="FONT-WEIGHT: bold; COLOR: #e26b0a"></TD><TD style="FONT-WEIGHT: bold; COLOR: #e26b0a"></TD><TD style="FONT-WEIGHT: bold; COLOR: #e26b0a"></TD><TD style="FONT-WEIGHT: bold; COLOR: #e26b0a"></TD><TD style="FONT-WEIGHT: bold; COLOR: #e26b0a; TEXT-ALIGN: center"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">7</TD><TD style="FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Dept</TD><TD style="FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Lname</TD><TD style="FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Fname</TD><TD style="FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Age</TD><TD style="FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Gender</TD><TD style="FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Sales</TD><TD style="FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Commission</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">8</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid">K-12</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Day </TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Janice</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">32</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">F</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">1,075,800 </TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">9</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid">Higer Ed</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Angston</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Lee</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">27</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">M</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">5,500,400 </TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">10</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid">K-12</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Wyler</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Deshanet</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">56</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">F</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">1,589,000 </TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">11</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid">Trade</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Cole </TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Arlene</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">30</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">F</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">11,500,000 </TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">12</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid">K-12</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Ruiz</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Jorge</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">39</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">M</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">5,347,500 </TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">13</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid">Higer Ed</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Grazier</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Kim</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">25</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">F</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">3,005,000 </TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">14</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid">K-12</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Lipes</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Jim</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">57</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">M</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">2,300,500 </TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">15</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid">K-12</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Steinberg</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Josh</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">28</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">M</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">2,500,000 </TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">16</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid">K-12</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Beam</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Saul</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">34</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">M</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">5,500,000 </TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">17</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid">Trade</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Yenkle</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Lisa</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">33</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">F</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">3,200,000 </TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">18</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid">Trade</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Wyler</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Len</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">38</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">M</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">10,900,000 </TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">19</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid">Higer Ed</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Stavish</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Napoleon</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">47</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">M</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">5,890,000 </TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">20</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; BORDER-BOTTOM: black 1px solid">Higer Ed</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Goldberg</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid">Joan</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">62</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: center">F</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right">3,000,000 </TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">21</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">22</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">23</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">24</TD><TD style="FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; BORDER-BOTTOM: black 1px solid; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">25</TD><TD style="BORDER-RIGHT: black 1px solid; BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; COLOR: #ffffff; BORDER-BOTTOM: black 1px solid; BACKGROUND-COLOR: #f79646">Dept</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; BORDER-LEFT: black 1px solid; COLOR: #ffffff; BORDER-BOTTOM: black 1px solid; BACKGROUND-COLOR: #f79646">Rate</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">26</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold">K-12</TD><TD style="BORDER-TOP: black 1px solid; FONT-WEIGHT: bold; TEXT-ALIGN: right">6.50%</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">27</TD><TD style="FONT-WEIGHT: bold">Higher Ed</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right">7.50%</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR><TR><TD style="COLOR: #161120; TEXT-ALIGN: center">28</TD><TD style="FONT-WEIGHT: bold">Trade</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right">8.50%</TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD><TD style="FONT-WEIGHT: bold; TEXT-ALIGN: right"></TD></TR></TBODY></TABLE>

Anderson Scholastic Employees​

One way...

=F8*VLOOKUP(A8,A$26:B$28,2,0)

 

[tills069]

I figured it out, In the book for lab 1, Ex 352 wants the A25:B28. Our Assignment wants A2:B4.

Cell G8: =F8*INDEX($B$2:$B$4,MATCH(A8,$A$2:$A$4,0))

 

[Arlene012248]

Are you in spreadsheets POFI 1449 with grantham? If so how what formula did you use for lab step 6 about the gender and average age.

Removed E-Mail Address - Moderator

 

[Smitty]

Welcome to the Board!

I removed your e-mail address, as it's not secure in this, or any other public forum. If you need to give it to someone, you can use the PM feature, which is secure from spambots and other things that look for vulnerable information.

 

[Arlene012248]

I am in the same program as you . I could use some help with chapter 5 lab1 part 3 arlene