Populate a cell based on selections made that reference a table

[JARUT1978]

I have a column with Priority that I want to be populated with a value between 1 and 3 based on inputs that reference a table in another worksheet.

Calculated Priority

Cost

Time to Implement

<colgroup><col width="92"><col width="97"><col width="107"></colgroup><tbody>
</tbody>

Possible values:

	Time
Cost	<6 months	>6 months	>1 year
<$500	1	2	3
>$500	1	2	3
>$1000	3	3	3

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

So, if on my worksheet I select "<$500" for cost and ">1 year" for Time to Implement the Calculated Priority field will be auto populated with the number "3".