Calculating the new column value based on other other columns in a list

Question

Is it possible to do something like following:
1) Select project(a drop down value from a column)
2) select dept( again a drop down drom a column from the list)
3) hit find new number. it will calculate next  number based on earlier numbers in the list.