I am trying to do a lookup from a table based on 4 criteria. 3 criteria are entered via drop down lists, and one is a constant. See below. I need a formula that will deliver the results in F10. I believe there are several ways to acomplish this, I think with Index And/Or Match, but I am having trouble.
The entire table has a named range of "Costs". This is a little over my head, so hopefully this is not too difficult. Any help is very much appreciated! Thank you!
Below is a sample from the table. The table is much larger.
<TBODY>
</TBODY>
The entire table has a named range of "Costs". This is a little over my head, so hopefully this is not too difficult. Any help is very much appreciated! Thank you!
Below is a sample from the table. The table is much larger.
A3</SPAN> | B</SPAN> | C</SPAN> | D</SPAN> | E</SPAN> | F</SPAN> | G</SPAN> | H</SPAN> | I</SPAN> | ||
4</SPAN> | Billing</SPAN> | 12435180</SPAN> | 12435181</SPAN> | 12435165</SPAN> | 12435173</SPAN> | 12435196</SPAN> | 12435197</SPAN> | |||
5</SPAN> | Region</SPAN> | East</SPAN> | East</SPAN> | West</SPAN> | West</SPAN> | National</SPAN> | National</SPAN> | |||
6</SPAN> | Area</SPAN> | NY</SPAN> | NY</SPAN> | CA</SPAN> | CA</SPAN> | TX</SPAN> | TX</SPAN> | |||
7</SPAN> | Type</SPAN> | Project</SPAN> | Dedicated</SPAN> | Project</SPAN> | Dedicated</SPAN> | Project</SPAN> | Dedicated</SPAN> | |||
8</SPAN> | ||||||||||
9</SPAN> | ResourceA</SPAN> | $ 100.00 </SPAN> | $ 80.00 </SPAN> | $ 105.00 </SPAN> | $ 85.00 </SPAN> | $ 120.00 </SPAN> | $ 115.00 </SPAN> | |||
10</SPAN> | ResourceB</SPAN> | $ 90.00 </SPAN> | $ 70.00 </SPAN> | $ 95.00 </SPAN> | $ 75.00 </SPAN> | $ 110.00 </SPAN> | $ 105.00 </SPAN> | |||
11</SPAN> | ResourceC</SPAN> | $ 80.00 </SPAN> | $ 60.00 </SPAN> | $ 85.00 </SPAN> | $ 65.00 </SPAN> | $ 100.00 </SPAN> | $ 95.00 </SPAN> | |||
12</SPAN> | ResourceD</SPAN> | $ 70.00 </SPAN> | $ 50.00 </SPAN> | $ 75.00 </SPAN> | $ 55.00 </SPAN> | $ 90.00 </SPAN> | $ 85.00 </SPAN> | |||
13</SPAN> | ||||||||||
14</SPAN> | Crieteria</SPAN> | Results</SPAN> | ||||||||
15</SPAN> | Region</SPAN> | West</SPAN> | From Data Validation List</SPAN> | Rate</SPAN> | ???</SPAN> | Formula to deliver results in F10</SPAN> | ||||
16</SPAN> | Area</SPAN> | CA</SPAN> | From Data Validation List</SPAN> | |||||||
17</SPAN> | Type</SPAN> | Project</SPAN> | Always ="project"</SPAN> | |||||||
18</SPAN> | Resource</SPAN> | ResourceB</SPAN> | From Data Validation List</SPAN> |
<TBODY>
</TBODY>