Beginner to Excel - Can you please help me solve this problem? (2 questions)

[wiserkid]

.1 I'm trying to find a formula that matches the suitability of each worker for the group to which the worker is assigned.

Suitability rating
Group 1 Group 2 Group 3 Group 4
Assigned to Worker 1 2 3 4
4 1 9 8 6 8
1 2 10 0 5 6
3 3 5 8 10 5



Considered using vlookup, hlookup - but just not sure how they work exactly

2. Number of ads Price per ad
1-5 12k
6-10 11k
11-20 10k
21 and higher 9k

I'm trying to find a formula that yields the total cost of purchasing any number of ads. For example, if you buy 8 ads, you pay $11,000 per ad, but if you buy 14 ads, you pay$10,000 per ad.

 

[Latchmaker]

Answer to your second question.

Copy and paste in A1
<style type="text/css">
table.tableizer-table {
border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
}
.tableizer-table td {
padding: 4px;
margin: 3px;
border: 1px solid #ccc;
}
.tableizer-table th {
background-color: #104E8B;
color: #FFF;
font-weight: bold;
}
</style><table class="tableizer-table">
<tr class="tableizer-firstrow"><th>5</th><th>12000</th><th> </th><th> </th></tr>
<tr><td>10</td><td>11000</td><td> </td><td> </td></tr>
<tr><td>20</td><td>10000</td><td> </td><td> </td></tr>
<tr><td>21</td><td>9000</td><td>INPUT QTY BELOW</td><td>RESULTS BELOW</td></tr>
</table>

 

[Latchmaker]

This is the formula to paste in D5 =IF(C5<A1+1,C5*B1,IF(C5<A2+1,C5*B2,IF(C5<A3+1,C5*B3,C5*B4)))

 

[wiserkid]

Thanks! Much appreciated!

I figured out the first problem using INDEX...

 

[skywriter]

I don't know what the first part means.

Excel 2010
	A	B	C	D
1	Ads	Price	Qty	Cost
2	0	$12,000	5	$60,000
3	6	$11,000
4	11	$10,000
5	21	$9,000
Sheet5

Cell Formulas
Range	Formula
D2	=LOOKUP($C2,$A$2:$A$5,$B$2:$B$5)*C2

 

[wiserkid]

Thank you! this forum is great