# Populate a cell based on selections made that reference a table

#### JARUT1978

##### New Member
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".

### Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Replies
1
Views
164
Replies
5
Views
182
Replies
0
Views
257
Replies
0
Views
187
Replies
1
Views
428

1,220,954
Messages
6,157,042
Members
451,394
Latest member
indrajeet_rajput

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back